Unable to open excel spreadsheet in automation anywhere

Question

I am using Automation Anywhere for inserting values into an excel file. I used the below code for opening the spreadsheet. But the spreadsheet is opening in excel app instead of Microsoft Excel on my computer. I don't have the license for Outlook Excel App

Excel: Open Spreadsheet "C:\Users\my_user\Documents\xyz.xlsx".ActiveSheet:"Default".Contains Header,Session:Default

Can anyone help me with this issue?

Answer 1

There are two ways that come to mind you can follow the steps and it should work for you

• Open regedit -> navigate to Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\(your version here)\options
• From "File" create a new DWORD, call it NoRereg, and set its value to 1

• After that - you'll need to go to the Programs and Features and repair Excel or the Office suite depending on how it's installed

• Restart when done

 you can always try this  :

• Launch Excel from C:\Program Files (x86)\Microsoft Office\Office14\Excel.exe
• Object Cloning-Set Text or keystrokes into Excel window to do CTRL+O
• Type in pathname of file and press enter