View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bharath Rajamani Bharath Rajamani is offline
external usenet poster
 
Posts: 41
Default 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