You need to open the workbook first, then use Application.Run to execute the
macro. E.g.,

Workbooks.Open "C:\path\FileName.xls"
Application.Run "FileName.xls!MacroName"
Workbooks("FileName.xls").Close savechanges:=False

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"santoshkumar" wrote in message
...

I am required to run macro in closed excel workbook using VBA.
pl help


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/