Import text file and create new spreadsheet
 

Hi all !

First, I would like to say I'm a VBA novice, I'm not a programmer. I
really don't know how to do the following question:

I have a large CSV file, in alphabetical order, with hundreds (maybe
thousands) of lines (for example, a catalog from a shoes shop). I need
to import this file to Excel and every time the name of each
manufacturer changes (the first column in CSV file), a new sheet must
be created and the name "SheetX" (Sheet1, Sheet2, etc...) must be
renamed with the name of the manufacturer. How can I do this using a
VBA Macro ? Please, help me !

It's something like:


- Read the first line;
- Rename Sheet1 to manufacturer's name;
- Fill the cells with all content from the manufacturer's name;
- When read a new manufacturer's name:
- Rename Sheet2 to manufacturer's name;
- Fill the cells with all content from the manufacturer's name;
- repeat until EOF.



Please, help me !
Thanks a lot !!

Demian.


--
demianill
------------------------------------------------------------------------
demianill's Profile: http://www.excelforum.com/member.php...o&userid=25676
View this thread: http://www.excelforum.com/showthread...hreadid=544815

Import text file and create new spreadsheet
 

If you don't get an answer, you can send me a sample textfile to


and I will write something for you.

--
Regards,
Tom Ogilvy


"demianill" wrote:


Hi all !

First, I would like to say I'm a VBA novice, I'm not a programmer. I
really don't know how to do the following question:

I have a large CSV file, in alphabetical order, with hundreds (maybe
thousands) of lines (for example, a catalog from a shoes shop). I need
to import this file to Excel and every time the name of each
manufacturer changes (the first column in CSV file), a new sheet must
be created and the name "SheetX" (Sheet1, Sheet2, etc...) must be
renamed with the name of the manufacturer. How can I do this using a
VBA Macro ? Please, help me !

It's something like:


- Read the first line;
- Rename Sheet1 to manufacturer's name;
- Fill the cells with all content from the manufacturer's name;
- When read a new manufacturer's name:
- Rename Sheet2 to manufacturer's name;
- Fill the cells with all content from the manufacturer's name;
- repeat until EOF.



Please, help me !
Thanks a lot !!

Demian.


--
demianill
------------------------------------------------------------------------
demianill's Profile: http://www.excelforum.com/member.php...o&userid=25676
View this thread: http://www.excelforum.com/showthread...hreadid=544815