saving multiple sheets into one csv file
 

I have multiple sheets each with over 60000 lines. I want to save it into one
csv file. Is there any quick code around it.

saving multiple sheets into one csv file
 

I think you can only have 1 sheet in a CSV file


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553139

saving multiple sheets into one csv file
 

thanks, but i ama ware of that. Im currently saving each sheet as a csv file
and then opening them as text file and appending the file information. Im
interested if there is a quicker way around it


"Mallycat" wrote:


I think you can only have 1 sheet in a CSV file


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553139