Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import text files into EXCEL | Excel Discussion (Misc queries) | |||
Import Multiple XML Files into Excel | Excel Discussion (Misc queries) | |||
import multiple csv files into excel 2007 | Excel Discussion (Misc queries) | |||
Import multiple text files (Macro) | Excel Discussion (Misc queries) | |||
Import multiple text files into a single worksheet | Excel Discussion (Misc queries) |