Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a string of unknown length in a string of unknown length, Help! | Excel Discussion (Misc queries) | |||
remove name of addin in Tools menu: "Document Project" | Excel Discussion (Misc queries) | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming | |||
self-installing add-in? | Excel Programming | |||
Excel Addin with drop-down menu | Excel Programming |