Excel 2003: "Workbook.Open with URL does not work

[Winfried.Kastner]

Hi,

In an Excel 2000 programm I had the VBA code:

Dim myWB As Workbook
Dim myXMLpage As String
.........
myXMLpage = "Here is the address of an external URL of a xml page"
Set myWB = Workbooks.Open(myXMLpage)

The value of myXMLpage looks like "http://www.xyz.com/502?tpl.xml".
Because of internal reasons I have to "hide" the corrrect address
standing behind "xyz.com" but the rest of the url is the same I use.

In Excel 2000 everything worked fine without any problems.

Since I moved to Excel 2003 VBA ends in a run time error while
executing the "Set myWB" command. I see that the open runs and thatb
the code tries to open but immediately later I get the run time error
with error numer 1004 and description "Method 'Open' of object
'Workbooks' failed." No other workbook is open in my Excel application
after the break.

Has anyone an idea how I get my programm running in Excel 2003 again?

Thanks in advance.
Winfried

 

[Kaak]

It's works fine with me.
I Tested: myXMLpage = "C:\Ticket.xml"

Wich version of excel 2003 are you using?
I know that the xml part is only available in the professional version

 

[Winfried.Kastner]

Hi,

I used Excel 2000 from the Professional Office package. As much as I
know Excel 2003 behaves identically independently what Office 2003
package you bought and have.

 

[Winfried.Kastner]

A normal file name works fine. I think the problem I have is when in
the URL contains a "?" or if the extension is "xml". The program was
not written by me otherwise I would chose a solution via a web query.

 

[Kaak]

No there is a diference for xml.

 

[Winfried.Kastner]

Hi Kaak,

This is interesting. Do you have any further information or a link for
me to get the information I need.

Regards
Winfried