Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Add-in not showing menu in Excel

Status
Not open for further replies.

MDA

Technical User
Jan 16, 2001
243
US
Hi all,

I have a VB app that adds an Add-in into Excel... However, for some reason when I install the add-in this way, the menu system in the add-in does not show??? Everything else seems to work but the custom menu in Excel??

My code in VB:
--------------------------------
Dim oXL As Object, oAddin As Object
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("C:\Program Files\XLPack\" & sEXCELFile, True)
oAddin.Installed = True
oXL.Quit
Set oXL = Nothing
------------------------------------

Any ideas are greatly appreciated!!!

Regards,

MDA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top