I have no idea about vb script though i tried to record a macro which does not solve my concern.

I have an XML file which i want to open in excel , which when done manually i select the 'As a Read only workbook' option.

So the excel should have a browse option to provide the xml file location and macro should then locate few columns (search the column header) and fetch the entire column values of the searched string and paste the details in new tab.

Please help me with this code.

Thanks in advance