Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
You might use the FileSearch Method. It will find ALL files that
match the criteria, which should be OK if there is just one. With Application.FileSearch 'Standard FileSearch Stuff .NewSearch .LookIn = "c:\my folder" .Filename = "*src data.XLS" .SearchSubFolders = False .Execute For i = 1 To .FoundFiles.Count 'Find the name of the workbook without the directory info WbFileName = Mid(.FoundFiles(i), InStrRev(.FoundFiles(i), "\") + 1, 200) workbooks.Open .FoundFiles(i) 'Do your processing here ... 'then close the workbook Workbooks(WbFileName).Close Next i End with |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I retrieve changes to an unsaved excel document | Excel Discussion (Misc queries) | |||
External data retrieve timescale | Links and Linking in Excel | |||
External data retrieve timescale | Excel Programming | |||
How do I retrieve changes to an unsaved excel document | New Users to Excel | |||
How can I retrieve an Excel document that I did not save? | Excel Discussion (Misc queries) |