0 votes
1 view
in RPA by (12.8k points)

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?

1 Answer

0 votes
by (29.8k points)

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
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...