Can you import CSV files as multiple worksheets?

Mar 13th, 2002, 09:35 PM

Is there a way to code worksheet breaks into a single CSV file so that it is imported into Excel as multiple worksheets in a single workbook?

Mar 14th, 2002, 07:14 AM

I looked at this a while back, and I do not believe that there is a direct way. What you could do, though, is write a macro to separate the stuff all out after it has already been imported.

-Josh

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 09:35 PM	#1
Guest Posts: n/a	Is there a way to code worksheet breaks into a single CSV file so that it is imported into Excel as multiple worksheets in a single workbook?

Mar 14th, 2002, 07:14 AM	#2
Guest Posts: n/a	I looked at this a while back, and I do not believe that there is a direct way. What you could do, though, is write a macro to separate the stuff all out after it has already been imported. -Josh