Click a button in Worksheet

[AthmanArumugam]

Hi,

I need to click a button in the first worksheet of the workbook using VB scripting.

Eg:
There is a button named "Run_1" in the worksheet. Run_1 is the button which executes the macro. I need to programmatically click this button from outside using VB Script.

Can anyone help me..

 

[Luke M]

You just need to know the name of the macro that the button calls, and then your new script would be something like:

Sub NewMacro()
Call OldMacroName
End Sub

 

[Hui]

You don't need to click a button
You can call the code directly from outside Excel using the techniques discussed here:
http://stackoverflow.com/questions/...utside-excel-using-vbscript-from-command-line