Excel - Worksheet: Renaming a Worksheet Name

Scripting Forums AppleScript | Mac OS X
,
#1

Does anyone have code that changes a worksheet name?

Ex. Name is “Worksheet1” to “Work1”

TIA

#2

Try this:-

tell application "Microsoft Excel"
	try
		set name of active sheet to "new_name_for_sheet"
	on error
		display dialog "Re-name failed." buttons {"Cancel"} with icon 0
	end try
end tell