How-Import 41 CSV files into 41 sheets?
 

i currently have a macro that will take 41 tabs of data and convert them into
41 "|" delimited csv files using each sheets tab name as the filename. Now I
have to reverse this process. This excel file will not be new, the data will
be importing into the 41 existing tabs that may or may not have data all
ready in them. Each tab has a header and some of the columns has to be in
text format due to having '0000' or '0123' as values (range of ph #'s).

Thanks in advance
Mintz

How-Import 41 CSV files into 41 sheets?
 

A good start would be Chip Pearson's sample code to import a file using a
custom delimiter:

http://www.cpearson.com/excel/imptext.htm import/export text files

You should be able to add the logic you need to handle your requirement.

--
Regards,
Tom Ogilvy

"Mintz87" wrote in message
...
i currently have a macro that will take 41 tabs of data and convert them
into
41 "|" delimited csv files using each sheets tab name as the filename.
Now I
have to reverse this process. This excel file will not be new, the data
will
be importing into the 41 existing tabs that may or may not have data all
ready in them. Each tab has a header and some of the columns has to be in
text format due to having '0000' or '0123' as values (range of ph #'s).

Thanks in advance
Mintz