checking the existence of a file in a webdatabase
I recently have started developing a macro with Excel and VBA. The data I work on are files on a web site. Before opening the file, I would like to check if the file exists or not so as to avoid a crash. According to the VBA book I have, I can use the the . LookIn function for a FileSearch.
Unfortunatelly, it seems that VBA does not recognize a path name
such as .LookIn = "http://www. ...". The path name does need to be .LookIn = "C:\ ...".
Do you know if there is a way in VBA to check the existence of the file on the web site, or if I am not using the proper command, or if it is a lost cause ?
I would appreciate somebody's help