View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Will Anikouchine Will Anikouchine is offline
external usenet poster
 
Posts: 3
Default VBA code to send click command to a macro in a different Excel workbook

My problem is the same as Raj's. I wish to write code in VBA to, in effect, remotely click a command button on a different worksheet. I needd a bit more guidance than "see help for Application.Run". I don't even know where to find that.

Any help would be greatly appreciated.



Posted as a reply to:

Macro code for clicking on Command Button in another workbook

Hi,

I have a workbook with macros. The macros open another workbook with
macros created by another person with code protected. A sheet in that
workbook has a command button that is to be clicked to run the macros
in that workbook. Is there a programmatic way by which I can click the
command button from my workbook macro code?

Thanks in Advance for the Help.

Regards,
Raj

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx