| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem with Excel file created programmatically
All,
I am using Excel 2007. I create an Excel file with my C# app and all is well.... except for add-ins. When I open the file that I created add-ins are not enabled. Actually I think they are enabled, but the Add-in menu is not on the menu bar, and when I enter a formula that references one, it does not work. However, they are checked in the Add- in window. Also, the Trust Center has macros enabled. What am I missing here? TIA, Bill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem with Excel file created programmatically
Are you opening Excel manually or via automation?
Add-ins do not load when Excel is opened using automation. Tim "bill" wrote in message ... All, I am using Excel 2007. I create an Excel file with my C# app and all is well.... except for add-ins. When I open the file that I created add-ins are not enabled. Actually I think they are enabled, but the Add-in menu is not on the menu bar, and when I enter a formula that references one, it does not work. However, they are checked in the Add- in window. Also, the Trust Center has macros enabled. What am I missing here? TIA, Bill |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem with Excel file created programmatically
On Jan 26, 10:02*pm, "Tim Williams" <timjwilliams at gmail dot com
wrote: Are you opening Excel manually or via automation? Add-ins do not load when Excel is opened using automation. Tim "bill" wrote in message ... All, Automation. That explains it. Is there a way to load add-ins via automation? TIA, Bill I am using Excel 2007. I create an Excel file with my C# app and all is well.... except for add-ins. When I open the file that I created add-ins are not enabled. Actually I think they are enabled, but the Add-in menu is not on the menu bar, and when I enter a formula that references one, it does not work. However, they are checked in the Add- in window. Also, the Trust Center has macros enabled. What am I missing here? TIA, Bill- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
problem with Excel file created programmatically
From:
http://groups.google.com/group/micro...09a32f7724e451 For Each tempAddin In oXL.AddIns If tempAddin.Installed Then oXL.Workbooks.Open (tempAddin.FullName) End If Next Tim "bill" wrote in message ... On Jan 26, 10:02 pm, "Tim Williams" <timjwilliams at gmail dot com wrote: Are you opening Excel manually or via automation? Add-ins do not load when Excel is opened using automation. Tim "bill" wrote in message ... All, Automation. That explains it. Is there a way to load add-ins via automation? TIA, Bill I am using Excel 2007. I create an Excel file with my C# app and all is well.... except for add-ins. When I open the file that I created add-ins are not enabled. Actually I think they are enabled, but the Add-in menu is not on the menu bar, and when I enter a formula that references one, it does not work. However, they are checked in the Add- in window. Also, the Trust Center has macros enabled. What am I missing here? TIA, Bill- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Original Excel File gets deleted and temp file gets created. | Excel Programming | |||
| Excell Problem when opening file created in another application!! | Excel Discussion (Misc queries) | |||
| Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
| Import csv file into excel programmatically | Excel Programming | |||
| Data from Programmatically created Excel into SQL Server | Excel Programming | |||
Hybrid Mode
