Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Naming Worksheet
I have a C# program accessing the Excel interop. No matter what I do,
I can't get the name of the active worksheet to change from "Sheet1". Here's basically the code. MSExcel.Application xlApp = null; MSExcel._Workbook wkb = null; MSExcel._Worksheet wks = null; string sheetName = "Opportunites"; xlApp = new MSExcel.Application(); wkb = xlApp.Workbooks.Add(MSExcel.XlWBATemplate.xlWBATWo rksheet); wks = (MSExcel._Worksheet) wkb.ActiveSheet; wks.Name = sheetName; Is there anything else I need to do? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem Naming Worksheet
I should have added that when I look at the worksheet name in the
debugger, it does appear as "Opportunities". However, when Excel is made visible, the sheet name is still named "Sheet1". wrote: I have a C# program accessing the Excel interop. No matter what I do, I can't get the name of the active worksheet to change from "Sheet1". Here's basically the code. MSExcel.Application xlApp = null; MSExcel._Workbook wkb = null; MSExcel._Worksheet wks = null; string sheetName = "Opportunites"; xlApp = new MSExcel.Application(); wkb = xlApp.Workbooks.Add(MSExcel.XlWBATemplate.xlWBATWo rksheet); wks = (MSExcel._Worksheet) wkb.ActiveSheet; wks.Name = sheetName; Is there anything else I need to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem naming range | Excel Worksheet Functions | |||
Problem naming tab- Keep getting .xls] in front | Excel Discussion (Misc queries) | |||
Excell column naming PROBLEM, HELP PLEASE | Excel Discussion (Misc queries) | |||
Naming a worksheet help? | Excel Worksheet Functions |