Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default unknown menu appear when installing an AddIn

hi,
we have created an Excel AddIn and installed this AddIn
with a macro.This AddIn as a build in menu attach to 1
workbook. No menu is created dynamically. But sometime
after installation in the AddIn Bar a other menu appear
Open, New close ...., where that come from???
I even unload and uninstalled any previous AddIn with the
same name.
Can any one help me?

This is the code.

Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.DisplayAlerts = False
'ExcelApp.Visible = True
Set xlBook = ExcelApp.Workbooks.Add

For Each ad In ExcelApp.AddIns
'Unload MyaddIn
If ad.Name = OLD_ADDIN_NAME &ADDIN_FILE_EXTENTION Or
ad.Name = NEW_ADDIN_NAME & ADDIN_FILE_EXTENTION Then
ad.Installed = False
End If
Next ad

'Delete menu bar
For Each ComBar In ExcelApp.CommandBars
If ComBar.Name = OLD_BAR Or ComBar.Name = NEW_BAR Then
ComBar.Delete
End If
Next ComBar

AddinName = REP_DESTINATION_ADDIN & NEW_ADDIN_NAME &
ADDIN_FILE_EXTENTION

ExcelApp.AddIns.Add FileName:=AddinName 'Add in the AddIn
list
ExcelApp.AddIns(NEW_ADDIN_NAME).Installed = True 'Install
the addin

xlBook.Close 'Close workbook

ExcelApp.Quit 'close Excel application
Set ExcelApp = Nothing
Set ad = Nothing
Set ComBar = Nothing

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
Finding a string of unknown length in a string of unknown length, Help! Hankjam[_2_] Excel Discussion (Misc queries) 8 July 3rd 08 06:49 PM
remove name of addin in Tools menu: "Document Project" Kate Excel Discussion (Misc queries) 2 January 9th 07 06:50 PM
Remove Excel AddIn from AddIn List !! Help carl Excel Programming 2 December 8th 03 03:36 PM
self-installing add-in? Mike[_37_] Excel Programming 5 August 22nd 03 04:42 PM
Excel Addin with drop-down menu Aparna Rege Excel Programming 1 July 14th 03 11:00 PM


All times are GMT +1. The time now is 07:51 AM.

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

About Us

"It's about Microsoft Excel"