Back

Explore Courses Blog Tutorials Interview Questions
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!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...