View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mcphc mcphc is offline
external usenet poster
 
Posts: 44
Default Check if file on intranet exists

I need to check if a file with path "http://pmnet/113-FR-001.xls" exists
without opening it. I've tried using Dir(myPath) but I get an error 52 'Bad
file name or number'. I've also tried using the FileExists method in VB but
I'm not sure how to use it.

Thanks