Results 1 to 5 of 5

Thread: vbscript import xml data to excel

  1. #1

    Thread Starter
    New Member
    Join Date
    Apr 2022
    Posts
    2

    vbscript import xml data to excel

    Hello !
    I have an excel spredsheet that needs to be completed with some static data and also variable data. This variable data is in a XML file, that I need to get some nodes and put this data in the excel spredsheet. I have done already a vbscript to complete the static data, but I donīt know how to use the XML inside the vb script.
    Any help is very welcome !
    thanks in advance

    omiexcel.vb
    OS_25764_dados_ecalc.xml

  2. #2
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,037

    Re: vbscript import xml data to excel

    Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.

  3. #3

    Thread Starter
    New Member
    Join Date
    Apr 2022
    Posts
    2

    Re: vbscript import xml data to excel

    Quote Originally Posted by jdc2000 View Post
    Excel can import .xml files. It might be easier to do that and use VBA to copy that data to the sheet you want to add it to.
    It has to be with vbscript because I use a software that automates the process, and this software rins the vbscript.

  4. #4
    Frenzied Member jdc2000's Avatar
    Join Date
    Oct 2001
    Location
    Idaho Falls, Idaho USA
    Posts
    2,037

    Re: vbscript import xml data to excel

    You could still use Excel to import the .xml data and transfer it, but automate that process using VBScript.

    Possibly useful links:

    https://docs.microsoft.com/en-us/pre...-side-vbscript

    https://www.softwaretestinghelp.com/...l-tutorial-11/

    https://automationscript.com/uft/rea...sing-vbscript/

  5. #5
    Member
    Join Date
    Apr 2022
    Posts
    60

    Re: vbscript import xml data to excel

    Consider serialization

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width