 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2008problem 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 Are you opening Excel manually or via automation? Add-ins do not load when Excel is opened using automation. Tim > All, > [quoted text clipped - 9 lines] > > Bill 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 > > > 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 [quoted text clipped - 9 lines] > > - Show quoted text - From: http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/ thread/aa03308fb1fc061/0e09a32f7724e451?hl=en&lnk=st&q=excel+automation+addins#0 e09a32f7724e451 For Each tempAddin In oXL.AddIns If tempAddin.Installed Then oXL.Workbooks.Open (tempAddin.FullName) End If Next Tim 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. [quoted text clipped - 6 lines] > > > 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 [quoted text clipped - 9 lines] > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.