Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links to other Workbooks lost | Excel Worksheet Functions | |||
Open a connection to dbf file | Excel Programming | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming | |||
How do I drop an Open connection in Excel | Excel Programming |