OnTheBeach
New Member
- Joined
- Sep 15, 2006
- Messages
- 1
Bit of a problem with application.filesearch.
Dim fs As FileSearch
....
Set fs = Application.FileSearch
fs.FileName = "*.*"
fs.SearchSubFolders = True
fs.NewSearch
fs.LookIn = "C:\Program files\Symantec\Act"
fs.Execute
jj = fs.FoundFiles.Count
For ii = 1 To jj
ff = fs.FoundFiles(ii)
Next ii
When I hit fs.filename = "*.*" (or any other string for that matter) I get a runtime error 5 invalid procedure call or argument.
The other properties works (i.e. newsearch etc - just this one.. Did a search thru object browser and it is there like all the other objects.
BTW - using Excel 97 on ME
Dim fs As FileSearch
....
Set fs = Application.FileSearch
fs.FileName = "*.*"
fs.SearchSubFolders = True
fs.NewSearch
fs.LookIn = "C:\Program files\Symantec\Act"
fs.Execute
jj = fs.FoundFiles.Count
For ii = 1 To jj
ff = fs.FoundFiles(ii)
Next ii
When I hit fs.filename = "*.*" (or any other string for that matter) I get a runtime error 5 invalid procedure call or argument.
The other properties works (i.e. newsearch etc - just this one.. Did a search thru object browser and it is there like all the other objects.
BTW - using Excel 97 on ME