Re: WORKBOOKS.OPEN (URL) - How to trap a connection-lost/ timeout erro

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ron de Bruin (rondebruin_at_kabelfoon.nl)
Date: 09/18/04 

Date: Sat, 18 Sep 2004 14:58:46 +0200

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" <BHARATHRAJAMANI@discussions.microsoft.com> wrote in message 
news:EB0E4878-22DE-4975-A11E-699AC0F2E187@microsoft.com...
>
> 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
Quantcast