Handling Non-Existing Web Files with Workbook.Open
I'm running some VBA to D/L some files (.csv files) from a web page/site. Works fine, except when the file doesn't exist. Thing is, I don't know if the file exists or not when I attempt to D/L it.
I'm using Workbook.open ("www.thewebpage.com/fileX.csv")...
which works fine until it hits the case where it can't find the file. Excel then pops a message saying effectively "Can't find the file dummy!" Of course, I want to automate this, as there's lot's of files to D/L. When this error occurs, how can I deal with it such that the VBA handles it and goes on to the next filename (that does exist) smoothly?