Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch Code
Hi
I am using the following code to open an excel file, but it is opening not the esact file Run.xls but another one ppp-Run.xls. What Change should I do? Thanks With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run.xls" .MatchTextExactly = True .FileType = msoFileTypeExcelWorkbooks End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch Code
Pedro,
I gave you sample code to solve this problem in answer to your first posting of this question. Please stay in the same thread. Regards, Tom Ogilvy "Pedro" wrote in message ... Hi I am using the following code to open an excel file, but it is opening not the esact file Run.xls but another one ppp-Run.xls. What Change should I do? Thanks With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run.xls" .MatchTextExactly = True .FileType = msoFileTypeExcelWorkbooks End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FileSearch Excel 2007 | Excel Discussion (Misc queries) | |||
Application.FileSearch | Excel Discussion (Misc queries) | |||
FileSearch in a combo box | Excel Discussion (Misc queries) | |||
FileSearch Problem | Excel Programming | |||
Exclude directory from .FileSearch | Excel Programming |