dump a multiple sheet excel file to a single text file

[Lynn McGuire]

Is there a way to dump a multiple sheet Excel file to a single
text file ? My understanding of CSV files is one CSV file per
sheet in the Excel file.

Thanks,
Lynn

 

[Dave Peterson]

You could combine the 4 csv files using an old DOS command.

Say you have 1.csv, 2.csv, ... 4.csv in a file called C:\myfiles

Open a command prompt window
Flying Windows key-r
type:
cmd
is one way of doing this

Traverse to that folder:
type:
c:
and hit enter

type:
cd \myfiles
and hit enter

Then type:
Copy 1.csv + 2.csv + 3.csv + 4.csv ALLFILES.csv
and hit enter

=========
Another option may be to copy all the data into a single worksheet and then do
your saveAs a CSV file.

 

[Lynn McGuire]

You could combine the 4 csv files using an old DOS command.

Say you have 1.csv, 2.csv, ... 4.csv in a file called C:\myfiles

Open a command prompt window
Flying Windows key-r
type:
cmd
is one way of doing this

Traverse to that folder:
type:
c:
and hit enter

type:
cd \myfiles
and hit enter

Then type:
Copy 1.csv + 2.csv + 3.csv + 4.csv ALLFILES.csv
and hit enter

=========
Another option may be to copy all the data into a single worksheet and then do your saveAs a CSV file.

Thanks, yes that is a good idea. I can write a C++ macro to dump
each Excel sheet to a separate CSV file then concatenate them.

Thanks,
Lynn

 

[CellShocked]

Is there a way to dump a multiple sheet Excel file to a single
text file ? My understanding of CSV files is one CSV file per
sheet in the Excel file.

Thanks,
Lynn

Let it make one per. Not one workbook each. One worksheet within a
single workbook. Then concatenate them together.

Fill up some sheets willingly then, then add the contents of those
subsequent sheets to the first either by script or by hand.

When done, delete the sub-sheets and be left with sheet one all filled
up..