View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J Streger J Streger is offline
external usenet poster
 
Posts: 101
Default MS Internet Transfer Control

using Excel 2003, I am trying to test to see if a file exists on a Sharepoint
Website. I find out that FileExists doesn't work, and read about inet.
Problem is I can't find this reference in my copy of Excel. I also manually
went searching for the .dll or .ocx but found neither. The sheet will be used
by others with the same set-up as me so I cannot just DL the file as it would
fail for them. Besides using error catching (which hangs for 30 seconds if it
can't find the file) is there another method to test to see if the file
exists, or am I missing where the transfer control is located?

--
*********************
J Streger
MS Office Master 2000 ed.
MS Project White Belt 2003

User of MS Office 2003