Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I reference a Worksheet from a Form (Add-in for Excel 2003)
Hi.
How can I reference the Worksheet (and Application) from a Form in an Add-in for Excel 2003? I have tried this code: Excel.Worksheet sheet = (Excel.Worksheet)this.Sheets["Sheet2"]; sheet.Select(Type.Missing); Excel.Range newFirstRow = sheet.get_Range("A1", Type.Missing); newFirstRow.Value2 = "This text was added by using code"; But I only get an error telling me that 'Form1' does not contain a definition for 'Worksheets'. I also tried this: Excel.Worksheet sheet = ((Excel.Worksheet)Application.ActiveSheet); Which led to the following error: 'System.Windows.Forms.Application' does not contain a definition for 'ActiveSheet' My goal is to do some calculations with my Add-in, present a summary of the calculations in the Add-in while saving all calculations in the Excel calling the Add-in. I am using Visual Studio 2008 for programming an Add-in for Excel 2003. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Copy Down Function to Reference Next Worksheet | Excel Worksheet Functions | |||
Drop-down list on simple excel 2003 form using "form" from data me | Excel Discussion (Misc queries) | |||
How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
How do I save worksheet form data into a table in Excel 2003? | Excel Discussion (Misc queries) | |||
Reference Access created form in excel | Excel Programming |