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

Vikram,

If you install the addin (ToolsAddins) 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" wrote in message
...
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

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
"Vikram Kohli" wrote in message
...
| 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

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 (ToolsAddins) 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" wrote in messag
..
Hi
I have created Excel an AddIn in VB and i wish to load it when my progra
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
Thank
Vikram Kohl

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
"Vikram Kohli" wrote in message
..
| 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

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
"Vikram Kohli" wrote in message
...
|
| 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
| "Vikram Kohli" wrote in message
| ...
| | 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
|
|
|

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


"Vikram Kohli" wrote in message
...

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
"Vikram Kohli" wrote in message
...
| 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

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 wrote:

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

"Vikram Kohli" wrote in message
...

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
"Vikram Kohli" wrote in message
...
| 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




--

Dave Peterson

Hi Dave,

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

"Dave Peterson" wrote in message
...
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 wrote:

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

"Vikram Kohli" wrote in message
...

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
"Vikram Kohli" wrote in message
...
| 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




--

Dave Peterson