If those are the only .csv files in the folder, you could shell to DOS and then
issue a couple of old commands to combine them and clean up:

Windows start button|Run
cmd (win2k or winXP)
command (win98)

Get to that folder

copy *.csv all.txt
del *.csv
ren all.txt all.csv

exit
to get back to windows.



Big Daddy wrote:

I'm a newbie with writing Excel Macros. Basically, what I am trying to do
is convert a workbook with multiple sheets into a single CSV file. I've
got the macro to activate each sheet one at a time and save it as .csv and
then after the last save it saves the workbook again in the normal workbook
format. However, the problem is, is that I have 30 .csv files and I don't
want to have to concatenate them all on the UNIX side. Is there a way to
merge these on the fly as I am saving them in csv format?

Thanks so much for your help.

Matt

--

Dave Peterson