Skip to main content
Question

How to use the [Microsoft 365 Excel: Open] action?

  • August 2, 2024
  • 1 reply
  • 80 views
B
Forum|alt.badge.img

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!!!!!!

1 reply

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Aaron.Gleason
  • Automation Anywhere Team
  • 544 replies
  • August 2, 2024

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


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings