Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the number of columns within existing column(s) | Excel Discussion (Misc queries) | |||
Excel 2007 Changing Existing Formulas | Excel Discussion (Misc queries) | |||
download existing spreadsheets into another existing spreadsheet | Excel Discussion (Misc queries) | |||
Changing case on text in an existing spreadsheet | Excel Discussion (Misc queries) | |||
Changing language of an existing sheet | Excel Discussion (Misc queries) |