merging multiple excel worksheets

[DJBittner]

we (our organization) have many standard forms within a folder used for recording data.
i need to extracted/export the data from each sheet into a comma separated values (.csv) data file for further processing. is there a method for appending spreadsheets together so i only have to export and process one data file instead of 60 - 70?

[pike]

Hi DJBittner
JB has many example which will help
https://sites.google.com/a/madrocket.../sheets-to-csv

[DJBittner]

JB's sollution got me ALMOST there .... i was able to get all of my files in a folder to get 'SavedAs' type '.csv' files but what i really want to do is .....

copy all worksheets in to one '.txt' file, say ToText.txt. in other words, each sheet's text data into one master text-file. btw, thanks for the help thus far.

[JBeaucaire]

From my website I would use the following 2 macros:

CSVs to Sheets

...to merge all CSVs into one workbook.

Sheets to One Sheets - Part 1

...to merge separate sheets into one sheet.


Then from this macro:

Sheets to TXT files

.
There's one line of code in there to save as TXT

Please Login or Register  to view this content.

...add that to the second macro.