Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open(URL) not working
Hi,
Can anyone suggest a workaround for the following in XL97 SR2 please? I'm trying to open a workbook from a web download, however, the workbook will not open if it is invoked from VBA (it is called from a Workbook_Open event). But it will work if I simply run the code. I can't find an explanation for this odd behaviour so I'm wondering if there is a workaround to download a sheet from this excel workbook held on a web site. Sub GetDataSheet strURL = "http://server//SpreadsheetToOpen.xls" Set myWB = Workbooks.Open (strURL) End Sub (btw, there is no other code in the Workbook_Open event and the URL is very simple with no strange characters). Many thanks in advance if anyone can help. Regards, Chris Adams |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open(URL) not working
Try moving the code from workbook_Open() to Auto_Open() (in a general module).
(Untested) wrote: Hi, Can anyone suggest a workaround for the following in XL97 SR2 please? I'm trying to open a workbook from a web download, however, the workbook will not open if it is invoked from VBA (it is called from a Workbook_Open event). But it will work if I simply run the code. I can't find an explanation for this odd behaviour so I'm wondering if there is a workaround to download a sheet from this excel workbook held on a web site. Sub GetDataSheet strURL = "http://server//SpreadsheetToOpen.xls" Set myWB = Workbooks.Open (strURL) End Sub (btw, there is no other code in the Workbook_Open event and the URL is very simple with no strange characters). Many thanks in advance if anyone can help. Regards, Chris Adams -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbooks.Open(URL) not working
Dave,
Many, many thanks - that worked a treat..!! I'm awestruck because its hard to tell how many years of experience went behind that simple, left-field solution :-) I've tested your solution on a couple of PCs so far - all worked fine. Heck of a relief because I'd made a commitment that this opening the URL workbook was easy stuff anyone could do, but then it blew up over this illogical problem and I've been sweating all weekend trying to figure a solution. You've saved my derriere! Much appreciated again, Chris Adams Dave Peterson wrote: Try moving the code from workbook_Open() to Auto_Open() (in a general module). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
duplicate workbooks open while working in that file | Excel Discussion (Misc queries) | |||
workbooks.open function fails to open an existing excel file when used in ASP, but works in VB. | Excel Programming | |||
Problem with Macro working in new workbooks that I open | 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 | |||
Workbooks.Open / .Open Text - How do you stop the .xls addition? | Excel Programming |