GMan
12-09-2005, 10:01 AM
I have a VBA script that is pulling a file from a Web site into Excel. Every once in a while the file being requested is not found and the VBA gets an error the the file can not be found. After clicking "OK", I receive an Microsoft VB error ('1004') stating again the file can not be access. But this message comes with the "END", "DEBUG", and "HELP" buttons.
Is there a more graceful way to handle this error. I can't use a DIR command to check for the file first because the I am not using a file path. The VBA Command to open the file is below:
Workbooks.OpenText Filename:=http:"//website.com/report/date12092005.csv"
Any help would be greatly appreciated. Being a beginner with VBA, I have not figured out all the basics with error handling yet as well as other basics I seem to get educated on with each issue I find myself facing.:banghead:
Thanks!
Is there a more graceful way to handle this error. I can't use a DIR command to check for the file first because the I am not using a file path. The VBA Command to open the file is below:
Workbooks.OpenText Filename:=http:"//website.com/report/date12092005.csv"
Any help would be greatly appreciated. Being a beginner with VBA, I have not figured out all the basics with error handling yet as well as other basics I seem to get educated on with each issue I find myself facing.:banghead:
Thanks!