Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filesearch in 2003
Hello,
I've recently been upgraded to Excel 2003. For some reason, a pretty standard filesearch function I'd been using now fails to pick up any files outside the root of C:. I've tried it in a machine still using 2000, and it works fine. Here's some example code: Sub blahblah() With Application.FileSearch .NewSearch .LookIn = "D:\" .searchSubFolders = true If .Execute 0 Then MsgBox .FoundFiles.Count End If End With End Sub This yields nothing, even if there is *definitely* files present, regardless of the filetype! Any suggestions???? Cheers and best, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filesearch in 2003
hi David
There are more problems with filesearch You can try Dir or FileSystemObject http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "David" wrote in message ... Hello, I've recently been upgraded to Excel 2003. For some reason, a pretty standard filesearch function I'd been using now fails to pick up any files outside the root of C:. I've tried it in a machine still using 2000, and it works fine. Here's some example code: Sub blahblah() With Application.FileSearch .NewSearch .LookIn = "D:\" .searchSubFolders = true If .Execute 0 Then MsgBox .FoundFiles.Count End If End With End Sub This yields nothing, even if there is *definitely* files present, regardless of the filetype! Any suggestions???? Cheers and best, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filesearch 1004 error with XL 2003 | Excel Programming | |||
Filesearch in VB6 | Excel Programming | |||
FileSearch | Excel Programming | |||
FileSearch using VBA | Excel Programming | |||
.FileSearch | Excel Programming |