LinkBack URL
About LinkBacksI have multiple sheets each with over 60000 lines. I want to save it into one
csv file. Is there any quick code around it.
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.
I think you can only have 1 sheet in a 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
>
>
Re: saving multiple sheets into one csv file
use below code. it will do the job.
usage
csvtoxls.pl list list.xls
Where list is a text list of files needed to added to a xls.
Please Login or Register to view this content.
jay
Thanks for the effort jay. It may not help the OP since its been 5 yrs+ since the topic was posted, but it will surely help others who search for this kind of issues.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
That was the idea. I faced this issue today. Couldn't find exact solution so wrote a script for my self and shared.
Jay
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks