Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings !
In a certain Folder I have a dozen text files all ending with .ali. These files all have an identical format, but different values. I occassionally need to change one particular field in all the files. How do I perform the "FOR" loop to address each file in turn ? What I did as a stop-gap was to open a DOS window in that folder, enter DIR *.ali Junk and then cut and paste the names from "Junk" into the module code, each on a separate line. I then put myFile(x) = " before each, and then changed the x to consecutive numbers. Then I put For N = 1 to 12 ThisFile = myFile(N) etc.... Tedious, I know, but it worked. But "there must be a better way" .... ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening multiple files sequentially | Excel Discussion (Misc queries) | |||
show most recent files first when opening excel files | Excel Discussion (Misc queries) | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) | |||
Opening CSV Files | Excel Programming |