Maybe you can try this

You can check your connection before you run your code
See the website from Randy Birch
http://vbnet.mvps.org


--
Regards Ron de Bruin
http://www.rondebruin.nl


"BHARATH RAJAMANI" wrote in message
...

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