LOC generator.xlsm

Hi Team,

I am given a task to develop a macro similar to attached file. Basically what I need to do is, when a raw data file in excel format is uploaded to excel and then it should get converted to a xml file . This need to be developed using a macro.

I want to set-up a button similar in the attached sheet which on pressing asks for the input file and then output file name, on pressing submit it generates the xml file.

I know the basic concept of creating a macro but I dint understand how the activities behind the button is performed. I am not aware of VBA coding, so if I can achieve everything with the normal Excel options. Please explain so that I can try the same.

Thanks in advance

Regards
Dhivya