View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Sub cannot run (Error 5)

try

.FileName = "*"


"Max" wrote:

Thanks, Patrick, but still no go here, I'm afraid. Tried putting in other
valid drives / paths, all attempts failed to run. Same error msg, same debug
line.

Even tried changing the debug line to say,:
..FileName = "*.bmp"
but it still failed to clear this line
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Patrick Molloy" wrote in message
...
as it is, the code works fine for me.
Try looking in another drive - D is
often used for CD/DVD