Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Excel Addin help!!!

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
Remove Excel AddIn from AddIn List !! Help carl Excel Programming 2 December 8th 03 03:36 PM
Excel Addin and Delegates in C# Claude Vernier Excel Programming 0 December 8th 03 10:37 AM
Excel Addin Yishi Excel Programming 1 November 12th 03 08:30 PM
Excel COM Addin vik Excel Programming 0 November 4th 03 10:19 PM
Problems with Excel Com Addin Chip Pearson Excel Programming 1 August 9th 03 10:11 AM


All times are GMT +1. The time now is 06:19 PM.

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"