![]() |
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 |
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