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

Help
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,
https://www.extendoffice.com/documents/excel/609-excel-rename-worksheets.html

Thanks,
Pankaj

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. vba - Programmatic Access To Visual Basic Project Is Not Trusted - Stack Overflow

6

Hey @Seonyong

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

Look Existing Post - Rename Single Excel Sheet - #8 by aksh1yadav

Regards…!!
Aksh

7

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