Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. Then a drop-down menu appears and a selection must
be made from it by the macro. Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? Many thanks in advance.

programmernovice formulated on Tuesday :
Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. Then a drop-down menu appears and a selection must
be made from it by the macro. Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? Many thanks in advance.

Try...

CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute

(Substitute the obvious expressions with actual menu text)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Jun 7, 7:06*pm, GS wrote:
programmernovice formulated on Tuesday :

Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. *Then a drop-down menu appears and a selection must
be made from it by the macro. * Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? * Many thanks in advance.

Try...

CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute

(Substitute the obvious expressions with actual menu text)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Many thanks Garry. Works like a charm.

On Jun 7, 8:06*pm, GS wrote:
programmernovice formulated on Tuesday :

Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. *Then a drop-down menu appears and a selection must
be made from it by the macro. * Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? * Many thanks in advance.

Try...

CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute

(Substitute the obvious expressions with actual menu text)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Garry, after the above procedure a box is opened by the outside
application requesting a password. Is there some way to enter one
using an Excel VBA macro? Thanks again for your help.

It happens that programmernovice formulated :
On Jun 7, 8:06*pm, GS wrote:
programmernovice formulated on Tuesday :

Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. *Then a drop-down menu appears and a selection must
be made from it by the macro. * Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? * Many thanks in advance.

Try...

CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute

(Substitute the obvious expressions with actual menu text)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Garry, after the above procedure a box is opened by the outside
application requesting a password. Is there some way to enter one
using an Excel VBA macro? Thanks again for your help.

What are you doing, EXACTLY? What is the "outside application"? Does it
take parameters for passing a password to it? ...need more info to be
able to better help you with this, but the solution will require that
you know the password.

You really need to provide more info AND even code sample from your
project if possible.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Jun 8, 2:06*pm, GS wrote:
It happens that programmernovice formulated :





On Jun 7, 8:06 pm, GS wrote:
programmernovice formulated on Tuesday :

Hi, I use Excel 2003 and need to write a macro that will simulate a
click on a button in the Excel toolbar, which has been put there by a
separate program. Then a drop-down menu appears and a selection must
be made from it by the macro. Can anyone supply me with a simple
script to do this, or alternatively, point me to where I may be able
to get help with it? Many thanks in advance.

Try...

CommandBars(1).Controls("MainMenuName").Controls(" SubMenuName").Execute

(Substitute the obvious expressions with actual menu text)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Garry, after the above procedure a box is opened by the outside
application requesting a password. *Is there some way to enter one
using an Excel VBA macro? *Thanks again for your help.

What are you doing, EXACTLY? What is the "outside application"? Does it
take parameters for passing a password to it? ...need more info to be
able to better help you with this, but the solution will require that
you know the password.

You really need to provide more info AND *even code sample from your
project if possible.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -

Thanks Garry. It's a very simple thing, a single line of code (which
you gave me)

CommandBars(1).Controls("RealTick®").Controls("Sta rt...").Execute

The application is called RealTick for Excel, and, as you see it puts
a button on the Excel
toolbar from which my macro selects "Start..." from the drop-down
menu, which produces the box requesting the password. I, of course
know the password, since I pay for their financial data service.
Hopefully this tells you enough. Your assistance and patience are
greatly appreciated.

Their website says they have APIs, which suggests you can automate this
software via code. I'd ask them what the APIs do and whether it can be
automated via Excel VBA. Chances look good that they can help you with
this!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc