locked
Convert excel file formatted in xml to excel workbook? RRS feed

  • Question

  • I have a excel file saved as XML spreadsheet 2003, I want to convert that excel file to a regular excel workbook without having to go into the file and do a save as, programmatically would be great. Thanks
    • Moved by CoolDadTx Thursday, May 14, 2015 5:32 PM Office related
    Thursday, May 14, 2015 4:16 PM

Answers

  • Hi vkid12,

    What's the version of excel? Does the regular excel means the general excel file?

    To convert xml excel file to the general excel file, we could open that xml file through excel application by using Workbooks.Open method, then we could save that file to other place with different format by using Workbook.SaveAs method.

    Simple sample:

    Dim app As New Excel.Application
    app.Visible = False
    Dim wb As Excel.Workbook
    Dim path As String
    path = "XXX"
    Set wb = app.Workbooks.Open(path)
    wb.SaveAs filename:="XXX"
    app.Quit
    Set wb = Nothing
    Set app = Nothing

    Regards

    Starain


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.



    Friday, May 15, 2015 5:35 AM