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/

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/

Not supported. The workbook has to be open to run a macro.

--
Regards,
Tom Ogilvy

"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/

If you mean run a macro contained in an open workbook and you want the macro
to draw data from a closed workbook, then you might look as SQL.Request on
Andy Wiggins site (see below)

or look at using ADO from Mr. Erlandsen's site:
http://www.erlandsendata.no/english/vba/adodao/

recent post from Andy Wiggins:

Tom, take a look at SQL.REQUEST, the function Microsoft supplies in its
XLODBC add-in. Not only can you use variable references to get data from
closed workbooks, you can also use it to update values in closed workbooks.

For illustrations on how to get data from closed workbooks see:
http://www.bygsoftware.com/examples/...SqlRequest.zip

It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--

Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

--
Regards,
Tom Ogilvy



"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/