I am trying to automate Excel containing Macro using UIPath, but its doesn’t even recognize the extension as with Macro the excel extension “.xlsm”, Also can you please help me with any example of how to select data from dropdown in excel
Are you working within the Excel Automation Scope activity? There should be no problem recognising the .xlsm format. You can then use the Execute Macro activity to call the macro within the workbook.
Your file will be not available in selection, but if you manually type filename with .xlsm extension then it will work.