Rename Excel spreadsheet from VBA code

  • Thread starter Thread starter Ken Snell
  • Start date Start date
K

Ken Snell

Assuming that xlApp is the object for your EXCEL application and that
xlWBook is the object for your workbook:

xlApp.xlWBook("OriginalSheetName").Name = "NewNameForSheet"
 
I have code that creates and exports to an Excel workbook.

How can I change the name of the sheets withing the book?
I can't seem to find a method to do this.

--
Jonathan Blitz
AnyKey Limited
Israel

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
Back
Top