changing existing spreadsheet
 

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

changing existing spreadsheet
 

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




"Jim" wrote in message
...
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