UiPath Excel error with Office 365

Help Studio
, ,
1

Hi,
I am getting this error with Office 365. How can I fix this? Thank you,

Copy Range: Unable to cast COM object of type ‘System.__ComObject’ to interface type ‘Microsoft.Office.Interop.Excel._Workbook’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{000208DA-0000-0000-C000-000000000046}’ failed due to the following error: The requested object does not exist. (Exception from HRESULT: 0x80010114).

1 Like
2

Hi @A_Learner

Check the below thread,

Hope it helps!!

2 Likes
3

Thank you, @mkankatala
Will try this.

Regards,

2 Likes
4

When I uncheck the visible check box, can I still execute the macro manually by sending hot keys into the Excel? Does unchecking make it possible?

Thank you so much,

1 Like
5

Can you show your workflow how it looks like… @A_Learner

1 Like
6

To run macro steps use
Excel Application Scope
Send hot keys - alt + F8 (opens macro window)
Type into
Click Create
etc. activities

Now if I uncheck visible property, will I be able to do the manual running of macro?
Thank you,

1 Like
7

To run macro we can use the activity present directly. And provide the Macro name and any parameters if you are passing

1 Like