I want to import multiple xml files in to one sheet.
A2 has to be file name(xml file name), B2 has to be date of file creation and time, C2 has to be folder name only(from which folder it was import) and D2 to G2 has to be the data from xml file. Each xml has 4 lines written in it and it is adjusting in D2 to G2.
I have to import thousands files everyday, when i import them in to cell, the cell height is increased for the entire row. I don't want it.
Need some help for macro or some short way, Please help me.
A2 has to be file name(xml file name), B2 has to be date of file creation and time, C2 has to be folder name only(from which folder it was import) and D2 to G2 has to be the data from xml file. Each xml has 4 lines written in it and it is adjusting in D2 to G2.
I have to import thousands files everyday, when i import them in to cell, the cell height is increased for the entire row. I don't want it.
Need some help for macro or some short way, Please help me.