VBA interface

Help Studio
, ,
1

VBA
VBA1197×293 20.2 KB

Check it above photo. I am facing vba interface issue. I have setup all settings in excel and UiPath studio. I have aaded excel in my tool. Still same issue i’m facing

2

Have you tried repairing MS Office?

3

Yes! It has been successfully repaired. But still same issue

4

Can you show the VBA code ?

5

Hi @Saikiran_K ,

Check this below attached workflow to rename the sheet in excel,
Uipath_RenameSheet.xaml (6.5 KB)

VBA Code:

Sub RenameSheets(oldSheetName,newSheetName)

Sheets(oldSheetName).Name = newSheetName

End Sub

Hope this helps :slight_smile:

6

Hi @Saikiran_K ,

Just check on the excel settings again using below link,

Hope this might help you :slight_smile:

1 Like
7

No still the same issue. It shows Invoke VBA: Interface not registered

8

Hi @Saikiran_K ,

Try with reinstalling office with trouble shoot steps with the below attached document,
UiPath Excel Addin Installation Troubleshooting v4.docx (388.6 KB)

For more informations check this below link,

Hope this may help you :slight_smile:

9

@Saikiran_K

Can you please run in debug…open locals panel and open exception details and check the error…as there you might get more info on what exactly is failing

Alternately if you can try reinstalling office…

Also check if macros are enabled and acticex is enabled in excel trust centre settings

Cheers

10

Hi @Saikiran_K ,

I have observed that files is not sastified the condition.

The file name should be .xlsm extension then only you can run the macros or VBA.

Regards,
Pavan kumar

11

is it?
let me check

12

Sure @Anil_G

1 Like
13

Hi Saikiran have you found a solution to your problem.
You might need to convert your .txt file into .vbs