View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How to call macro from other workbook

Application.Run "book2.xls!test_msgbox"


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ppyxl" wrote in
message ...

Hi,

I m running a macro from one of the excel workbook let s say workbook1,
i want to add a call macro code so that i can execute the macro in other
workbook2.

Guys, do u have any idea/

Thanks,
ppyxl


--
ppyxl
------------------------------------------------------------------------
ppyxl's Profile:

http://www.excelforum.com/member.php...o&userid=36116
View this thread: http://www.excelforum.com/showthread...hreadid=560641