mporting multiple text files into Excel with corresponding filenames

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 15

mporting multiple text files into Excel with corresponding filenames

Dear members,

I need to import 100+ text files into Excel.

In addition I want Excel to show corresponding filename (where the
data comes from) in each row.

How do I accomplish this?
TIA

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
importing multiple text files into Excel with corresponding filenames	avi[_2_]	Excel Programming	2	February 3rd 10 12:07 PM
Joel - Importing multiple text files to 1 spreadsheet, now importing from excel files	Volker Hormuth	Excel Programming	7	April 9th 09 06:55 PM
multiple text files to multiple rows in excel	Vindhyawasini	Excel Programming	1	January 3rd 08 03:04 AM
excel files in my docs have numbered filenames and are duplicates	sss	Setting up and Configuration of Excel	1	December 11th 07 11:37 PM
Acquiring filenames for multiple files with GetOpenFilename	John	Excel Programming	1	December 17th 03 06:51 AM

All times are GMT +1. The time now is 01:14 AM.

Menu

About Us