Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Addin that I've written that contains the normal things.
However, there are references to worksheets that must be updated from time to time. Rather than including these worksheets in the addin, I have chose to include them in a separate workbook that contains only those worksheets. I would like for the addin to open the workbook automatically. Below is the Workbook_Open Code for the addin. Private Sub Workbook_Open() Call CreateMenu 'Open File Dim moduleLineList As Object Dim filePath As String Dim fullPath As String Dim fileNam As String On Error Resume Next fileNam = APPNAME & "TechData.xls" filePath = Application.ThisWorkbook.Path fullPath = filePath & "\" & fileNam Set moduleLineList = GetObject(fullPath) End Sub This works fine on the .xls version of the addin, but whe I convert it to an AddIn and install it, i get errors including the class name for GetObject, etc. Any Suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open XL - A Powerful Excel Addin | Setting up and Configuration of Excel | |||
Open XL - A Powerful Excel Addin | Excel Worksheet Functions | |||
Open XL - A Powerful Excel Addin | Excel Worksheet Functions | |||
Open XL - A Powerful Excel Addin | Charts and Charting in Excel | |||
Copying a sheet from an addin into an open workbook | Excel Programming |