Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 14th, 2004, 11:28 AM
Registered User
Join Date: Jan 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Checking the contents of a text file for log-in Seifer Classic ASP Basics 10 December 18th, 2006 12:45 PM
Checking for controls existence .NET 2.0 sarosh General .NET 0 March 1st, 2006 02:30 AM
checking file exists on remote server pete_m Classic ASP Basics 11 August 2nd, 2004 02:35 AM
WebDatabase. SannOo Access 0 March 17th, 2004 01:13 AM
Checking if a file is already opened before writin flyin General .NET 1 February 27th, 2004 11:46 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.