excel - How to make VBA click a button in a different workbook? -


workbook 1 contains macro 1, wrote.

i'm using macro 1 send input data workbook 2, , retrieve calculations workbook 2. workbook 2's calculations require exercising macro 2, activated clicking command button button 6 in workbook 2.

the button name "button 6" , know name of macro initializes.

how click button 6 macro 1?

instead of clicking button in other workbook run button's click event function or intended function using application.run method.

application.run "workbookname!functionname"


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -