Rename Single Excel Sheet

Help
3

Thank you @KEntwistle.
Can you please send me the .vsb with an example of Sheet Names?
Thank you so much,
Camilla :slight_smile:

4

Sorry, not sure what a .vsb is?

1 Like
5

The .vbs is the containing the macro.
Can you please write an Example of Macro with only one Excel Sheet?
Thank you so much,
Camilla :slight_smile:

6

@CamiCat

Check this topic:

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

In the topic there is also an example .xaml file.

2 Likes
7

HI @KEntwistle ,@loginerror and friends ,

I have developed a custom activity to rename the excel sheet. The thing is I have Excel 2010. It is working well. But the @CamiCat is having the Excel 2016. Can you please any one to test it with other version except 2010. below the activity.

Regards
Balamurugan.S

2 Likes
8

Hey @CamiCat

You can do this by Invoke Code Activity Too :slight_smile:
// Without Hotkeys :slight_smile:
Rename Worksheet-Akshay Yadav.xaml (9.5 KB)

Let me know if you have any query with it :slight_smile:

Regards…!!
Aksh

4 Likes
9

Hi @aksh1yadav,

I have opened the xml it gives error. Something is missing ?

image

Regards
Balamurugan

1 Like
10

Hey @balupad14

Just due to my Other Interop library reference :slight_smile:

Check this :slight_smile: - Rename Worksheet-Akshay yadav.xaml (9.5 KB)

if still face problem :slight_smile:

Regards…!!!
Aksh

2 Likes
11

Hi @aksh1yadav,

Yes . It is working. But the same thing I have done in my Package “BalaReva.Excel.Activities”. I don’t know . Y it is not working…

Note:

I am expecting @CamiCat reply.

Regards
Balamurugan.S

1 Like
12

I have to check

I was not active from months and don’t get usually time to go through with all posts :slight_smile:

and TBH i have not checked your activity but can look into in some free time :slight_smile:

Cheers

Regards…!!
Aksh

1 Like
13

Thank you

I have some suggestion about the your activity. Have to do some changes for performance .
The objects has to do nothing. Instead passing a parameter the interop object has to declare inside the Invoke code activity.

Regards
Balamurugan.S

1 Like
14

Hey @balupad14

ohh those arguments for other intentions . can clear too just to take object back in studio for further usage :slight_smile:

Thanks :slight_smile:

Regards…!!
Aksh

15

Thank you so much @aksh1yadav. and @balupad14.

image
image1600×900 69 KB

Do you know how to solve it?
:relaxed::slightly_smiling_face:

16

What version you are using?
As i can see by view it is might be 2016.*? @CamiCat

In that case can share my Custom Activity but need to check for permissions :smiley:

Regards…!!
Aksh

1 Like
17

Hi @CamiCat,

Can you check have you installed the core activities package?

image

Regards
Balamurugan.S

1 Like
18

Hi @CamiCat,

I have done some technical changes related with Excel 2016 in the “BalaReva.Excel.Activities”. I uploaded the latest version 3.0.1. Can you please check it ?

Regards
Balamurugan.S

1 Like
19

Thank you @balupad14.
I’ll try and let you know.
Camilla :slight_smile:

20

Ok Thank you @CamiCat. I will wait.

Regards
Balamurugan.S

1 Like
21

Thank you so much @balupad14.
Now it works :slight_smile:
Camilla :slight_smile:

22

Thank very much … I was thinking to test in Excel 2016.

1 Like