How to split and export a table into multiple, dynamically named, csv files

[trilliansounds]

Hi,

Using VBA, I'm familiar with exporting the contents of an entire worksheet to a csv file but can someone help demonstrate how to export sections of a worksheet (see mtable.csv attached) into multiple csv tables named after the symbol name in column A and where the number of rows for each table differs? Ie the end result splitting mtable.csv is the following files (attached)... AA.csv, AAPL.csv and ACN.csv.

Thanks in advance

[jindon]

Assuming "mtable.csv" is also a true csv file.
Select "mtable.csv", when the code asked.

To a new workbook.

Please Login or Register  to view this content.

[trilliansounds]

That's great jindon, thank you. If the name of the csv file (variable "e" in the above code) is located in another column (say Column B instead of Column A) how would you declare that?

[jindon]

Try change to

Please Login or Register  to view this content.

[trilliansounds]

Thank again that works. One last request, how would I include a header row (row 1 of mtable.csv) in each file?

[jindon]

Not tested.

Please Login or Register  to view this content.

[trilliansounds]

Nearly there, this results in blank rows inserted:

Attachment 334083

[jindon]

No attachment...

[trilliansounds]

sorry, try this:
[URL deleted]

[jindon]

I need to see the main csv and the result that you want like you have uploaded in your first post.

[trilliansounds]

Here's the new source table with the filename now in Column B:
mtable-with header.csv

Current result:
AA-current output.csv
AAPL-current output.csv
(etc...)

And desired outcome:
AA-desired result.csv
AAPL-desired result.csv
(etc...)

Thanks

[jindon]

Fixed header?

Please Login or Register  to view this content.

[trilliansounds]

perfect, thank you!

[jindon]

That's good and thanks for the rep.

Can you mark this thread as "Solved"?