troubleshooting Question

Opening XML files in MS-Excel

Avatar of Charlie_Melega
Charlie_Melega asked on
XMLMicrosoft ExcelVB Script
1 Comment1 Solution253 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros