Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can anyone tell me what is wrong with this code. I get the Error "Object
variable or With block variable not set (Error 91)" Dim WSD As Worksheet Set WSD = Worksheets("Sheet1") WSD.XmlDataQuery("http://10.1.1.50/CGI/webXML2.exe").WSD.Range ("A15") Thank you, Steve |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't know anything about these features, but taking a look at the help
file, believe you need to Look at the help on the XmlImport Method of the Workbook. What your using would return the range where the data is mapped - not map the data. -- Regards, Tom Ogilvy "Steve Westwood" wrote in message ... Can anyone tell me what is wrong with this code. I get the Error "Object variable or With block variable not set (Error 91)" Dim WSD As Worksheet Set WSD = Worksheets("Sheet1") WSD.XmlDataQuery("http://10.1.1.50/CGI/webXML2.exe").WSD.Range ("A15") Thank you, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using position() in XmlDataQuery | Excel Discussion (Misc queries) | |||
Function using XMLDataQuery in Excel: Not refreshing automatically on worksheet | Excel Programming | |||
XmlMapQuery and XmlDataQuery Samples in Excel 2003 and VB.NET | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |