VBA interface

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

Have you tried repairing MS Office?

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

Can you show the VBA code ?

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:

Hi @Saikiran_K ,

Just check on the excel settings again using below link,

Hope this might help you :slight_smile:

1 Like

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

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:

@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

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