How to change the sheet name in xls file

Help Automation Ops
,
1

How to change the sheet name in xls file.If I MANUALLY CHANGING THE SHEETNAME, ITS NOT CHANGING .How to change it.

2

Hi @anjani_priya

Try this

image
image870×862 32.9 KB

Regards,

1 Like
3

I have tried, Its not working

4

@anjani_priya

Can you please share your excel file if its not confidential

Cheers!!

5

26.04.2024.xls (6 Bytes)
this is the file,sheet name not changing

6

I’ve had this issue too! If right-clicking to rename doesn’t work, make sure your file isn’t in protected mode. Restarting Excel often helps, or try copying the content to a new sheet if all else fails.

7

you can change the Name by using the VB Script code

ThisWorkbook.Worksheets("Sheet1").Name = "NewSheetName"
8

Hi @anjani_priya

can you follow the below thread.

1 Like
9

@Baskar_Gurumoorthy @anjani_priya

need to use the vs script for change the name

ThisWorkbook.Worksheets("Sheet1").Name = "NewSheetName"

@anjani_priya Did you tried this ?

10

Should I use this in assign?

11

I have tried its not working

12

Hi @anjani_priya

It seems your .xls file is corrupted. I have created the same .xls file and it working fine at my end.

Input:
image

image
image893×888 35.1 KB

Output:
image

Regards

1 Like
13

for my solution, you need to use vb script

I hope below activity help you for solution

14

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