Try

Application.Run "'" & ReportName & "'!Main"

--
HTH

Bob Phillips

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

"ppyxl" wrote in
message ...

Hi, thanks!

error msg still! macro not found

is it any speical setting for the macro in another excel work book


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