When I run "With Application.filesearch" (eg Copying some standard code off a vba website into a sheet a module and running it!), EVERY TIME it gets to
It always comes up with a value of zero - ie it skips the code and goes to the end if.Code:If .Execute > 0 Then ' my code End If
This applies to xls and doc file extensions, I have tried changing the sort properties, I have tried changing the SearchSubFolders property to true... everything.
I even downloaded the "standard" Excel example sheet from the VBA Express site and ran that on a folder that is full of files - and still it returns NO FILES. I tdoesn't return an error, it just doesn't recognise there to be any files in the folder (even with msoFileTypeAllFiles!)
I am using Ms Office 2003, in Excel, and the computer runs (fairly) normally for a PC on Windows.
Does anyone have any idea what is going on?!?
Thank you!




Reply With Quote
