LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Import multiple text files into excel

I have a folder located at -- c:\precedence
Inside the folder I have about 10 files named as follows:
NC60.txt
NC61.txt
NC62.txt
NC63.txt
NC90.txt
NC91.txt
NC5801.txt
NC01.txt
NC02.txt
L64.txt

Each of the files is sent to me by different individuals,
hence the different names. Each files contains the same
formatting of information. I have created a macro that
will let me import NC60.txt into a new sheet in the open
workbook. I want to automate the process so that it will
go to the folder, import the NC60.txt to a new worksheet,
then it will loop through and add NC61.txt to a new
worksheet and so on and so forth until it has imported all
files. I have a setup file in the worksheet where I list
each file name so it might be used as a reference. Any
assistance would be appreciated.

If it is easier to discuss this or have me send you the
text files, you can email me at Walter.(REMOVE THIS)


Thanks for a busy soldier in Iraq.

Wally Steadman


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Import text files into EXCEL Annette Excel Discussion (Misc queries) 1 March 1st 09 10:16 PM
Import Multiple XML Files into Excel Mungkol Excel Discussion (Misc queries) 3 January 22nd 09 01:37 PM
import multiple csv files into excel 2007 Annie - torston Excel Discussion (Misc queries) 1 January 15th 09 06:24 AM
Import multiple text files (Macro) Thr33of4 Excel Discussion (Misc queries) 0 September 19th 06 02:19 AM
Import multiple text files into a single worksheet Scott Excel Discussion (Misc queries) 0 January 13th 05 10:22 PM


All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"