View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Sub cannot run (Error 5)

Max,
VBA Help has examples.

NickHK

"Max" wrote in message
...
Thanks, Nick
Dir( ) produces reliable results.

How could the sub be amended to make use of the above ?
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"NickHK" wrote in message
...
Max,
People always seem to get unexpected behaviour with .Filesearch, across
versions of Windows and Office.
Dir( ) produces reliable results.

NickHK