Load On Demand Addins

[Guest]

Hi

I have created Excel an AddIn in VB and i wish to load it when my program opens excel. What is the code that i have to write for that. I have already set the startup option in addin to "Load On Demand". Plz.. Hel

Thank

Vikram Kohli

 

[Bob Phillips]

Vikram,

If you install the addin (Tools>Addins) and check it, it always loads when
Excel starts.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,

I have created Excel an AddIn in VB and i wish to load it when my program

opens excel. What is the code that i have to write for that. I have already
set the startup option in addin to "Load On Demand". Plz.. Help

 

[Jim Rech]

The loading of standard Excel add-ins is controlled through Tools, Add-ins.
If this is a COM Add-in its loading is controlled through Tools, COM
Add-ins. That menu item is not visible by default in Excel. To add it to
your menu you have to go into View, Toolbars, Customize. Go to the Commands
tab and the Tools category. You'll find COM Add-ins in the list of
commands. All you have to do is drag it to your Tools menu.

--
Jim Rech
Excel MVP
| Hi,
|
| I have created Excel an AddIn in VB and i wish to load it when my program
opens excel. What is the code that i have to write for that. I have already
set the startup option in addin to "Load On Demand". Plz.. Help
|
| Thanks
|
| Vikram Kohli

 

[Guest]

Hi Bob

1) My addin is a dll not an xla file.
2) I don't want my addin to load every time when excel starts instead i want it to load when i click on a button from my ex

Thank

----- Bob Phillips wrote: ----

Vikram

If you install the addin (Tools>Addins) and check it, it always loads whe
Excel starts

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

Hi

opens excel. What is the code that i have to write for that. I have alread
set the startup option in addin to "Load On Demand". Plz.. Hel

 

[Guest]

Hi ji

There is no command as COM Add-In when i have selected Tools category in Visual Basic

----- Jim Rech wrote: ----

The loading of standard Excel add-ins is controlled through Tools, Add-ins.
If this is a COM Add-in its loading is controlled through Tools, COM
Add-ins. That menu item is not visible by default in Excel. To add it to
your menu you have to go into View, Toolbars, Customize. Go to the Commands
tab and the Tools category. You'll find COM Add-ins in the list of
commands. All you have to do is drag it to your Tools menu

--
Jim Rec
Excel MV
| Hi

| I have created Excel an AddIn in VB and i wish to load it when my program
opens excel. What is the code that i have to write for that. I have already
set the startup option in addin to "Load On Demand". Plz.. Hel

| Thank

| Vikram Kohli

 

[Jim Rech]

I was speaking of Excel not VB. The COM Add-in item should be added to
Excel's Tools menu if this add-in is written to work with Excel.

--
Jim Rech
Excel MVP
|
| Hi jim
|
| There is no command as COM Add-In when i have selected Tools category in
Visual Basic.
|
| ----- Jim Rech wrote: -----
|
| The loading of standard Excel add-ins is controlled through Tools,
Add-ins.
| If this is a COM Add-in its loading is controlled through Tools, COM
| Add-ins. That menu item is not visible by default in Excel. To add
it to
| your menu you have to go into View, Toolbars, Customize. Go to the
Commands
| tab and the Tools category. You'll find COM Add-ins in the list of
| commands. All you have to do is drag it to your Tools menu.
|
| --
| Jim Rech
| Excel MVP
| | | Hi,
| |
| | I have created Excel an AddIn in VB and i wish to load it when my
program
| opens excel. What is the code that i have to write for that. I have
already
| set the startup option in addin to "Load On Demand". Plz.. Help
| |
| | Thanks
| |
| | Vikram Kohli
|
|
|

 

[Gerrit van Stempvoort]

Hello Jim,

I have more or less the same problem as Vikram.
In my VB Menu bar is a option Add-Ins. If I click that option I got an
Add-In Manager showing a empty box of available Add-Ins and no option to ad
one.
When I follow your suggestion View>Toolbars>Commands I see in the command
column an function "Additional Controls". However, when I drag that one to
the Menu bar it is not possible to activate it.
How can I made this function active? I'm using Office 2000 (which is
different from older versions on this point, according to the help file) and
VB 6.3.

 

[Dave Peterson]

I think you missed Jim's "Tools Category" reference.

View|toolbars|Commands Tab|Tools Category|COM Add-ins... (about half way down)

Drag it to your favorite toolbar. (I put mine right below Tools|Addins)

 

[Gerrit van Stempvoort]

Hi Dave,

I was using View etc. in VB, but I should use the EXCEL tab. Now it's
working, thanks.