I am getting a error with XmlDataQuery

[SJW62]

Can anyone tell me what is wrong with this code. I get the Error “Object variable or With block variable not set (Error 91)” This error occurs at run time.


Dim WSD As Worksheet

Set WSD = Worksheets("Sheet1")
WSD.XmlDataQuery("

http://10.1.1.50/CGI/webXML2.exe").WSD.Range

("A15")


Thank you,





Steve

 

[PHV]

And this ?
WSD.XmlDataQuery("

http://10.1.1.50/CGI/webXML2.exe").Range

("A15")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SJW62]

Thanks PHV for the try but that gave me a compiler error.

 

[rmikesmith]

Steve,

According to the VBA Help, the syntax for the XmlDataQuery method is

expression.XmlDataQuery(XPath, SelectionNamespaces, Map)

and returns a range mapped to XPath. You cannot tack a range reference onto the end of this method.


Regards,
Mike

 

[SJW62]

Thanks for the help.
I saw that under help but the compiler shows “expression.XmlDataQuery(XPath, [SelectionNamespaces], [Map])As Range”. This has the “As Range” outside the brackets. Ether way how do I direct were the data goes?


Thank you,



Steve

 

[rmikesmith]

Steve,

Not sure I can help with this, as I don't know what this function is actually doing (I don't even know what an XPath is!). However, from the Help entry:
XMLAvailabilityNoteReturns a Range object that represents the cells mapped to a particular XPath. Returns Nothing if the specified XPath has not been mapped to the worksheet, or if the mapped range is empty
it appears that something (i.e. mapping an XPath to a worksheet) needs to be in place beforehand.

Maybe someone else will weigh in on this.

Mike