View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default can not assign value to LookIn

See answer to your second posting of this question.

--
Regards,
Tom Ogilvy

"QQExcel" wrote in message
m...
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..........