Thread: check filename
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
GS GS is offline
external usenet poster
 
Posts: 364
Default check filename

<FWIW

While the suggested approache(s)/solution(s) do address the OP's situation
explicitly (ie. his current session), your suggestion doesn't work because
it returns TRUE if the file exists, whether it's open or not, or in use or
not.

You might also want to specify that this test requires that wb be Variant
type. Even though it appears that it is (implicit in your code), someone
reading this may spent a lot of frustrating time trying to figure that out
using Option Explicit.


Regards,
Garry