Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by SJW62

  1. SJW62

    I am getting a error with XmlDataQuery

    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
  2. SJW62

    I am getting a error with XmlDataQuery

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

    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)” 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")...
  4. SJW62

    XML Data

    Thanks for the help BUT "ADODB.Recordset" dose not appear to be valid for Excel’s VBA. The error I get is "User-defined type not defined”.
  5. SJW62

    XML Data

    I am a new user of VBS. I have a web site that when given the (http://10.1.1.50/CGI/webXML.exe?name=Steve) URL, with arguments, returns, XML formatted data. I would like to pull that data into some sort of record set that I can walk through. I need to do this dynamically. What object...
See more

Part and Inventory Search

Back
Top