Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
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 -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564622 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
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. Kaak schrieb: 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 -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564622 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
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. schrieb: 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. Kaak schrieb: 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 -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564622 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
No there is a diference for xml. -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564622 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003: "Workbook.Open with URL does not work
Hi Kaak,
This is interesting. Do you have any further information or a link for me to get the information I need. Regards Winfried Kaak schrieb: No there is a diference for xml. -- Kaak ------------------------------------------------------------------------ Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513 View this thread: http://www.excelforum.com/showthread...hreadid=564622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem getting "detect and repair" to work in Excel 2003 | Excel Discussion (Misc queries) | |||
Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
"Open With" Excel Does Not Work For TXT File Extension | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming |