Call Macro in Other Workbook

[cogent]

Hello

If I am running a macro in ThisWorkbook, MyFile.xls, and I want to Call a
subroutine in Personal.xls, how can I do that? What is the syntax? Let's
assume the name of the procedure I want to call from Personal.xls is PMacro.

Sub Call_PMacro

???

End Sub

Thank you!

 

[Chip Pearson]

The simplest way is to use the Application.Run method. E.g.,

Application.Run "MyFile.xls!PMacro"


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

 

[Ron de Bruin]

Hi cogent

Use Application.run to call a macro in a other open workbook
Some notes on this from Chip Pearson

Application.Run "Book1.xls!MacroName"

Or, if the book name contains spaces, (watch the quotes)

Application.Run "'Book One.xls'!MacroName"

 

[Tom Ogilvy]

See your bubble thread for a possible solution to your previous problem.

 

[cogent]

What if I need to pass values to the PMacro? or Example the routine is
PMacro(datum1, Datum2).

Will the quotes allow that I pass values to PMacro?

W

 

[Chip Pearson]

If the procedure returns a value, use syntax like

Result = Application.Run ("'MyFile.xls'!PMacro", arg1, arg2)

If the procedure doesn't return a value, use
Application.Run "'MyFile.xls'!PMacro", arg1, arg2


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

 

[Wayne P. Weddington III]

Thank you.

W

If the procedure returns a value, use syntax like

Result = Application.Run ("'MyFile.xls'!PMacro", arg1, arg2)

If the procedure doesn't return a value, use
Application.Run "'MyFile.xls'!PMacro", arg1, arg2


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