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