| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening and closing files in order with vba
I am wanting to open and close a excel file named PS 01-01-98 through PS 01-01-2004 in order and extract data from each file untill I reach the last file. I already have the code written to extract the data, but am not sure how to open the next filename in order. Any help would be greatly appreciated
thanks, shane |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
opening and closing files in order with vba
Hi Shane,
myFile = Dir(" path to the first file in the folder... \FirstFile.xls") Do Until myFile="" perform the operations on myFile myFile=Dir() NOTE: Do not include the path to the folder here Loop HTH, Greg "shane" wrote in message ... I am wanting to open and close a excel file named PS 01-01-98 through PS 01-01-2004 in order and extract data from each file untill I reach the last file. I already have the code written to extract the data, but am not sure how to open the next filename in order. Any help would be greatly appreciated. thanks, shane |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| order of opening files with sumproduct returning #REF! | Excel Worksheet Functions | |||
| OPENING AND CLOSING OF EXCEL 07 FILES | Excel Discussion (Misc queries) | |||
| Excel 2003/2007 Crash when opening/closing files | Excel Discussion (Misc queries) | |||
| Opening and closing workbook with VBA... | Excel Programming | |||
| Opening and closing text files | Excel Programming | |||
![shane[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
