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