Skip to main content

Hello guys!!!

  I hava met a question about how to use the Microsoft 365 Excel: Open] action to open a local .xlsx file. 

  When I run the bot,there is a error message : The data entered in “filePathVariable” is incorrect. In that case,what type of parameter should I input?

That’s all.

Thanks!!!!!!

That action isn’t for opening local files (e.g., files on your C: drive). This only opens files on your OneDrive in the “My Files” folder.

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/using-open-workbook-action.html

If you want to open a local file, use the Excel Advanced: Open action to open the file in Excel, or Excel Basic: Open to open XLSX (only) files without needing Excel installed.

 


Reply