Rename Single Excel Sheet


#1

Hello friends,

I would like to rename the Excel Sheet of this file
Arricchimento_2018_07_20_092424.xlsx (20.8 KB)

in “Foglio1”, without using hotkeys.
How is it possible to do that?
Thank you so much,
Camilla :slight_smile:


#2

Hi, you could execute a macro?

The VBA for such an activity could be simply:

WS.Name = [whatever name you like]


#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?


#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.


#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


#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


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

Hi @aksh1yadav,

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

Regards
Balamurugan


#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


#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


#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


#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


#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.


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


#17

Hi @CamiCat,

Can you check have you installed the core activities package?

image

Regards
Balamurugan.S


#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


#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