Thread
:
how to run macro of closed excel workbook using VBA
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
how to run macro of closed excel workbook using VBA
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/
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson