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:

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

Sorry, not sure what a .vsb is?

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:

@CamiCat Check this topic: [image] Is there anyway to change excel sheet name without useing send hot key or rewriting sheet? Help Hello @Seonyong , Below article can solve your problem, https://www.extendoffice.com/documents/excel/609-excel-rename-worksheets.html Thank…

Hey @CamiCat [image] CamiCat: How is it possible to do that? 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

Hi @aksh1yadav , I have opened the xml it gives error. Something is missing ? [image] Regards Balamurugan

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

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

I have to check [image] balupad14: But the same thing I have done in my Package “ BalaReva.Excel.Activities ”. I don’t know . 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 som…

[image] aksh1yadav: I was not active from months and don’t get usually 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 Thank you I have some suggestion about the your activity. …

Hey @balupad14 [image] balupad14: 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. ohh those arguments for other intentions …

Rename Single Excel Sheet

Help

aksh1yadav (AKSHAY YADAV) July 20, 2018, 10:20am 10

Hey @balupad14

Just due to my Other Interop library reference

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

if still face problem

Regards…!!!
Aksh

Rename the excel

Topic		Replies	Views
Is there anyway to change excel sheet name without useing send hot key or rewriting sheet? Help	5	6626	July 20, 2018
Renaming a sheet in Excel Help excel	10	4986	December 11, 2018
How to rename the specific sheet on excel? Help excel , activities	12	8675	October 27, 2018
Rename a sheet in workbook Help	20	7983	August 27, 2019
Adding and renaming excel sheet in a workbook Help	6	5231	September 16, 2019

Rename Single Excel Sheet

Related topics