Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, everyone,
I saw couple messages regrad to Lookin property, but still can't get mine. Here is my code: FilePath = ThisWorkbook.Path & "\Phase1_Comments\" Set FS = Application.FileSearch With FS .LookIn = """" & FilePath & """" .FileName = FileSpec .Execute If .FoundFiles.Count = 0 Then MsgBox "No files were found, ........." Exit Sub End If End With ThisWorkbook.Path is a hyperlink address as http://he2.... ..LookIn refers to C:\Documents and Seetings\... and won't change to FilePath Anyone could help me? Appreciated.......... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookin property of the FileSearch object | New Users to Excel | |||
Assign F1 as a macro? | Excel Discussion (Misc queries) | |||
assign | Excel Discussion (Misc queries) | |||
Lookin Property. | Excel Programming | |||
Using a variable with .LookIn | Excel Programming |