Menu

Import text file and create new spreadsheet

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

Tom Ogilvy Tom Ogilvy is offline

Tom Ogilvy is offline

external usenet poster

Posts: 6,953

Default

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Create an "import-friendly" text-file from excel?	Mikael Lindqvist	Excel Discussion (Misc queries)	3	January 9th 08 04:39 PM
Create a single xls file with each import csv file having its own tab	[email protected]	Excel Discussion (Misc queries)	1	September 19th 07 08:38 PM
Import Text File Into A Spreadsheet with over 65,000 lines	Ecohouse	Excel Programming	1	January 10th 06 11:42 PM
How do I import text file, analyze data, export results, open next file	Geoffro	Excel Programming	2	March 6th 05 08:02 PM
can i create an excel xml map without having an import file?	RVSutherland	Excel Programming	2	March 1st 05 03:24 AM

All times are GMT +1. The time now is 02:09 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement