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.

If you don't get an answer, you can send me a sample textfile to
twogilvy@msn.com

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
>
>