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


#1

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


#2

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


#3

thanks


#4

Hello @Seonyong,

Below article can solve your problem,

Thanks,
Pankaj


Rename Single Excel Sheet
#5

@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


#6

Hey @Seonyong

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

Look Existing Post - Rename Single Excel Sheet

Regards…!!
Aksh