Avatar of Charlie_Melega
Charlie_Melega
 asked on

Opening XML files in MS-Excel

Hello,

I am looking to automate the process to open many XML Files in Microsoft Excel. I can do this manually by:
1) specifying the XML file to open
2) The following prompt appears:

 xmlopenoptions

As shown, "Use the XML Source Task Pane"  is chosen. This option allows me to chose specific fields to import in and display in the spreadsheet.

3) I choose the specific fields I want and then "Import" data into excel to populate those specific fields.

4) I rename the column headings to what I need.


The question I have is if there is any way to automate this process via a script or a native "automation" function within Excel. Ideally, I'd like to create a separate sheet for each XML file I import in.

Thank You
Microsoft ExcelXMLVB Script

Avatar of undefined
Last Comment
akitsupport

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
akitsupport

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes