Is there anyway to change excel sheet name without useing send hot key or rewriting sheet?

Is there anyway to change excel sheet name without useing send hot key or rewriting sheet?
maybe just by using codes

maybe, you can use [Execute Macro] activity to change the sheet name ,
just with codes in 2 lines of the macro.

thanks

Hello @Seonyong,

Below article can solve your problem,
https://www.extendoffice.com/documents/excel/609-excel-rename-worksheets.html

Thanks,
Pankaj

@Seonyong Here is the XAML importing VBA. Main.xaml (6.0 KB)

And here is the macro code:

Sub ChangeSheetName(SheetOldName As String, SheetNewName As String)
Sheets(SheetOldName).Name = SheetNewName
End Sub

You may have to enable trust. https://stackoverflow.com/questions/25638344/programmatic-access-to-visual-basic-project-is-not-trusted

Hey @Seonyong

Yes you can use VB.Net Code with Invoke Code Activity :slight_smile:

Look Existing Post - Rename Single Excel Sheet

Regards…!!
Aksh

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.