Exporting multiple worksheets to one .CSV

[BenGiesbertz]

Hi all,

I have a s/sheet that consists of 5 worksheets, that I need to export
to a SINGLE CSV file for interrogation by third party software. ie I
need all 5 worksheets exported to the once CSV file. The process will
be automated by a VB script.

There are two catches.

1. Since each worksheet will always have a varying number of rows, it
would be difficult to copy all the worksheets onto one worksheet and
then export in bulk.

2. The last row of data that I would like exported is not the last row
of the worksheet.

I hope I've explained myself properly. If not I'm happy to answer any
questions that I can. Thanks in advance.

B

 

[Alan Cocks]

Ben

I would combine all 5 worksheets into a sixth worksheet, and then save this
sheet as a csv file. I if you do have problems you can always open the csv
file with Word (Plain text) and actually see where the commas are.

Alan

 

[Alan Cocks]

Have you had any success?
If not try saving each sheet individually as a .csv file

open them with Word
Copy and paste them into one word file
once you can see the file structure and the commas tidy up the joins, and
the commas.
Usually the commas should follow some kind of pattern.

Save it as "Plain Text" (change the .txt suffix to .csv
Open it with Excel and see if everything is in the right place.
If not copy and paste.

I am no expert, but as no one else answered I am putting in my 2 cents
worth!

Alan

Ben

I would combine all 5 worksheets into a sixth worksheet, and then save this
sheet as a csv file. I if you do have problems you can always open the csv
file with Word (Plain text) and actually see where the commas are.

Alan