Trying to convert .xml to .xlsx

[mayoung]

I have been searching for code to convert a .xml to .xlsx and open it. I have found several examples but when you go to open the .xlsx file it comes up with
an error file corrupted or extension does not exist or something to that regards? Can anyone help me out?

I have tried just converting without changing the file path or name. But that was unsuccessful also. I am self taught at VBA and struggle when it comes to more complexed things.
I have also tried recording the process but that produces pop ups which I do not want either. I have tried using Application.displayalerts=false but that does not help. Can someone please help me? Thank You in advance.

Current: C:\user\myoung\downloads\DataminerFile.xml

Convert to and Open File: C:\user\myoung\downloads\parts\Parts Order-081420.xlsx



And divert all popups.

 

[sandy666]

import XML into Power Query, transform (or no) as you wish then load into the worksheet

 

[mayoung]

import XML into Power Query, transform (or no) as you wish then load into the worksheet

Will try it and let you if it works for me. Thank You for your suggestion.

 

[mayoung]

Is there not a VBA way to convert a .xml to .xlsm? I am trying to automate this task from a button in ribbon I created?

 

[sandy666]

Is there not a VBA way to convert a .xml to .xlsm? I am trying to automate this task from a button in ribbon I created?

IMHO Power Query is much better but this is your choice what you will do

 

[sandy666]

or just Developer tab - Import - XML file

 

[mayoung]

or just Developer tab - Import - XML file

I figured out a code to change this over works perfect. Thank you for your suggestions.

 

[sandy666]

I don't understand why open an open door, but if it works it's ok
Have a nice day