Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing VSTO Workbook Methods
I'm using VSTO with VB in VS 2008 and Excel 2007, and trying to understand
something basic. I've written some public methods in ThisWorkbook.vb, which is the class created by VSTO with "Public Class ThisWorkbook". Suppose one method I've writtine in the workbook is Public TestMethod. If I am writing code in a worksheet, e.g. Sheet1.vb, and I want to access TestMethod, how do I do it? TestMethod is under the ThisWorkbook class, and is not a shared method. If I write ThisWorkbook.TestMethod, it says it's a non-shared member and requires an object reference. Do I create an new instance of ThisWorkbook in Sheet1, or will this confuse VSTO/Excel? -- Ed |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VSTO - How to find all Pivot tables in the Workbook | Excel Programming | |||
Missing Excel Workbook Template - with VSTO SE installed | Excel Programming | |||
VSTO 2005 - How to use ThisWorkbook as an Excel.Workbook | Excel Programming | |||
Refreshing the data in a shared workbook with VSTO | Excel Programming | |||
Hidden workbook properties/methods | Excel Programming |