changing existing spreadsheet

J

Jim

Hello, I have not done anything like this so....

It's possible to programmatically (in .NET) open an *.xls file, make changes
(specifically rename worksheets) and save the file/changes correct?

Thanks in advance,
Jim
 
C

Chip Pearson

Jim,

Try something like

Dim WB As Excel.Workbook
WB = XL.Workbooks.Open("H:\Test\BookName.xls")
WB.Worksheets("OldSheetName").Name = "NewSheetName"
WB.Close True

where XL is your instance of the Excel Application.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top