Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Add-In has menu for user but not for Automation ?

Hi - I'm using an AddIn which when added creates a menu. The same
workbook when opened via C#/interop shows that that the AddIn is
present and installed but the menu is not there.

I'm not an Excel expert - is this surprising behaviour in an AddIn ?
The same user runs Excel ' manually' as runs the .EXE which automates
Excel - I don't understand why their experience is different.

Could anyone suggest a means to make the menu visible ?

thanks

Richard.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Add-In has menu for user but not for Automation ?

When Excel is started by automation, addins and files in the startup folder
(eg Personal.xls) are not loaded. It's up to the app that automated Excel to
load any installed addins if/as required. Should also note that in this
scenario Auto_Open & _close routines will not automatically run (can use
RunAutoMacros)

Regards,
Peter T

"northof40" wrote in message
...
Hi - I'm using an AddIn which when added creates a menu. The same
workbook when opened via C#/interop shows that that the AddIn is
present and installed but the menu is not there.

I'm not an Excel expert - is this surprising behaviour in an AddIn ?
The same user runs Excel ' manually' as runs the .EXE which automates
Excel - I don't understand why their experience is different.

Could anyone suggest a means to make the menu visible ?

thanks

Richard.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Add-In has menu for user but not for Automation ?

Hi Peter - Thanks very much for this. It throws light on a number of
things I have seen in trying to automate Excel - I will try the
RunAutoMacros idea.

regards

R.


On Aug 28, 1:20 am, "Peter T" <peter_t@discussions wrote:
When Excel is started by automation, addins and files in the startup folder
(eg Personal.xls) are not loaded. It's up to the app that automated Excel to
load any installed addins if/as required. Should also note that in this
scenario Auto_Open & _close routines will not automatically run (can use
RunAutoMacros)

Regards,
Peter T

"northof40" wrote in message

...

Hi - I'm using an AddIn which when added creates a menu. The same
workbook when opened via C#/interop shows that that the AddIn is
present and installed but the menu is not there.


I'm not an Excel expert - is this surprising behaviour in an AddIn ?
The same user runs Excel ' manually' as runs the .EXE which automates
Excel - I don't understand why their experience is different.


Could anyone suggest a means to make the menu visible ?


thanks


Richard.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to add Menu Bar to User form kris Excel Programming 2 November 22nd 07 12:07 PM
Visible automated Excel: automation crashes if user selects cells, protection? Christian Friedrich Excel Programming 1 November 3rd 06 04:26 AM
Office Automation - Capturing Custom Menu Clicks luai7 Excel Programming 3 June 16th 05 05:19 PM
Persistent menu item with Excel Automation Add-in? [email protected] Excel Programming 2 January 10th 05 05:51 PM
Knowledge gained from Access to Excel VBA Automation User request ImraneA Excel Programming 0 January 29th 04 04:35 PM


All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"