Help with VB macro for Excel
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.
|