WORKBOOKS.OPEN (URL) - How to trap a connection-lost/ timeout erro
Set wbkMyWorkbook = Workbooks.Open(URL)
Using this statement, I try to open a .csv file on a remote (securities
exchange) website. How might I trap the error(s) of: network connection
timeout, Excel process not responding, HTTP file not found.
My macro was working great until yesterday, but today it eats up CPU
resources - process-not-responding. I am able to debug, independently
retrieve the URL string & download the CSV file by pasting the (debug) URL
string on the browser window.
I am on Excel XP & a 64kbps connection to the Internet.
Any ideas why the macro dies?
TIA!!
Regards,
BR
--
Manager, International Private Banking, International Banking Group, ICICI
Bank
East Wing 8th floor South, ICICI Towers, Bandra Kurla Complex, Mumbai India
400051
|