ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I am getting a error with XmlDataQuery (https://www.excelbanter.com/excel-programming/338964-i-am-getting-error-xmldataquery.html)

Steve Westwood[_2_]

I am getting a error with XmlDataQuery
 
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




Tom Ogilvy

I am getting a error with XmlDataQuery
 
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







All times are GMT +1. The time now is 01:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com