View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Sub cannot run (Error 5)

"Dave Patrick" wrote:
Check that you can manually traverse the folders
in question with your logon.


Confirmed, no problem. I can see the folder contents.

Try some other directories
possibly with SearchFolders = False


Tried other directories, and with the suggested setting
but it still hangs at the same line:
..FileName = "*.*"

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--