error with vba and LookIn

G

Guest

Hi,

This code return an error. Why ?
--
Set fs = Application.FileSearch
With fs
.LookIn = "ftp://10.217.2.3"
.SearchSubFolders = True
.Filename = "*.txt"
 
B

BrianB

Probably because it mimics the File/Open menu, so if you cannot open
he file there the function will not work either.

Regards
BrianB
====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find all the files in a folder 1
Open a .pdf file using vba in excel 2003 6
counting xls files in a folder 8
VBA - exporting serial letters to single documents 0
Macro issue 5
application.filesearch error in excel 2007 3
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Application.FileSearch in Excel 2007! 3

Top