Load On Demand Addins

V

Vikram Kohli

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
 
B

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)

Vikram Kohli said:
Hi,

I have created Excel an AddIn in VB and i wish to load it when my program
Click to expand...
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
 
J

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
 
V

Vikram Kohli

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

Vikram Kohli said:
Hi
Click to expand...
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
 
V

Vikram Kohli

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
 
J

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
|
|
|
 
G

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.
 
D

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)
 
G

Gerrit van Stempvoort

Hi Dave,

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