PC Review


Reply
Thread Tools Rate Thread

Add-Ins aren't loading

 
 
Allen Lance
Guest
Posts: n/a
 
      13th Apr 2007
Hello,

I have an external app that is opening Excel. When Excel loads none
of the add-ins are being loaded with it. The add-ins are listed and
checked in the add-in installation box. However none of the add-in
code seems to have activated (i.e. no custom menus are loading). None
of the add-ins are showing up in the VBA project explorer.

If I save the spreadsheet generated by the external app then open that
spreadsheet from scratch then I get all the add-ins.

I suspect that the external app is a VB6.0 app and I didn't code it so
if there's an issue with the ext. app I can't fix that.

Any suggestions?

Thanks,
Allen

 
Reply With Quote
 
 
 
 
Tim
Guest
Posts: n/a
 
      13th Apr 2007
Opening Excel via automation doesn't load any add-ins: you'll have to load
them via code.
This will be a bit tricky though if you don't have access to the code
openeing Excel.

Tim


"Allen Lance" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I have an external app that is opening Excel. When Excel loads none
> of the add-ins are being loaded with it. The add-ins are listed and
> checked in the add-in installation box. However none of the add-in
> code seems to have activated (i.e. no custom menus are loading). None
> of the add-ins are showing up in the VBA project explorer.
>
> If I save the spreadsheet generated by the external app then open that
> spreadsheet from scratch then I get all the add-ins.
>
> I suspect that the external app is a VB6.0 app and I didn't code it so
> if there's an issue with the ext. app I can't fix that.
>
> Any suggestions?
>
> Thanks,
> Allen
>



 
Reply With Quote
 
Peter T
Guest
Posts: n/a
 
      13th Apr 2007
Hi Allen,

Indeed with automation you need to open the addins, eg,

Sub test()
Dim objAddin As Object ' if early binding declare fully
Dim objWB As Object

With CreateObject("Excel.Application")
On Error Resume Next ' problem with some, eg funcres.xla
For Each objAddin In .AddIns
If objAddin.Installed Then
Set objWB = .Workbooks.Open(objAddin.FullName)
objWB.RunAutoMacros xlAutoOpen
End If
Next
.Visible = True
End With

End Sub

might also want to open Personal.xls from the startup folder

Regards,
Peter T

"Allen Lance" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I have an external app that is opening Excel. When Excel loads none
> of the add-ins are being loaded with it. The add-ins are listed and
> checked in the add-in installation box. However none of the add-in
> code seems to have activated (i.e. no custom menus are loading). None
> of the add-ins are showing up in the VBA project explorer.
>
> If I save the spreadsheet generated by the external app then open that
> spreadsheet from scratch then I get all the add-ins.
>
> I suspect that the external app is a VB6.0 app and I didn't code it so
> if there's an issue with the ext. app I can't fix that.
>
> Any suggestions?
>
> Thanks,
> Allen
>



 
Reply With Quote
 
Allen Lance
Guest
Posts: n/a
 
      13th Apr 2007
Thanks for the suggestions guys. Since I don't have access to the
code I'll just have to deal with this through documentation rather
than automation

Allen

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why aren't my emails aren't downloading? Trishka15 Microsoft Outlook Installation 3 11th Mar 2008 08:37 AM
My messages aren't being sent, but they aren't in the outbox =?Utf-8?B?U0VD?= Microsoft Outlook Discussion 4 30th Sep 2006 10:57 AM
Why aren't images pre-loading? =?Utf-8?B?QmV2ZXJseS1UZXhhcw==?= Microsoft Frontpage 3 28th Aug 2006 01:53 AM
Some Web Pages Aren't Loading Bubey Windows XP Internet Explorer 1 11th Jun 2006 09:23 PM
icons aren't loading up right PaulXXX Windows XP General 1 20th May 2004 03:53 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:49 PM.