Question: how to fetch data from xml file to excel sheet using vba?
Answer: Open a Excel workbook (xls or xlsx).
Click 'File' menu & choose 'Open' (shortcut – 'Alt+F+O').
Browse folder path & choose XML file.
Click 'Open' or press 'Enter'.
Choose 'As an XML table' in popup menu & click 'OK'.