Skip to main content
S
shyamkalaskar
Cadet | Tier 2
February 29, 2024
Question

An unknown error occurred when executing the 'OpenExcel' command. To continue, contact your system administrator.

  • February 29, 2024
  • 5 replies
  • 549 views

I am trying to access the excel file using advance excel, I have given correct path and I have a license version of Microsoft office. while running bot I have a following error, kindly help me.

“An unknown error occurred when executing the 'OpenExcel' command. To continue, contact your system administrator.”

    5 replies

    S
    Automation Anywhere Team
    sikha.p
    Automation Anywhere Team
    February 29, 2024

    Please check this KB https://apeople.automationanywhere.com/s/article/Error-message-An-unknown-error-occurred-when-executing-the-OpenExceI-command

      S
      shyamkalaskarAuthor
      Cadet | Tier 2
      February 29, 2024

      Hi Shikha, this link is on customer portal, I am not able to access this. can you please post the solution here instead of link.

      S
      Automation Anywhere Team
      sikha.p
      Automation Anywhere Team
      February 29, 2024

      Please register at Apeople.

       

      L
      Cadet | Tier 2
      Laura 2507
      Cadet | Tier 2
      March 1, 2024

      Hi @shyamkalaskar I had the same issue recently and it was related to the VBA code in the file. So if the file you are trying to open is .xlsm then I found a workaround which was to tick the reference ‘AccessibilityCplAdmin 1.0 Type Library’ under Tools>References in VBA and after that was done and saved, the Excel Advanced: Open error stopped. 

      S
      Semih 3318
      Pathfinder Advocate | Tier 6
      March 7, 2024

      Hi, be sure that you have the excel file which you mention in OpenExcel command. then you may try restarting controlroom service, and try again

      Terms & ConditionsAccessibility statement