Convert data file to xml file RRS feed

  • Question

  • I have a log file that I want to convert into an xml file and then view it in Excel 2010. Actually I have several files so I would like to automate a procedure like this:

    1. Prompt User to browse and select one log file (example.log)
    2. Delete the last line in the file (contains a check sum that prevents the data to be interpreted as an xml file)
    3. Prompt User to select a location to place a copy of the file and change file extension to xml (example.xml)
    4. Import the file in Excel in a xml table in cell A1

    Does anyone know if it is possible to automate this using VBA in Excel?

    Any help is greatly appreciated


    Saturday, March 1, 2014 7:10 AM