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

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

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 -

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 -