calling modules

Pedro · Nov 13, 2003

Hi
How to call a sub in a module that is in other workbook?
thanks
Pedro

Chip Pearson · Nov 13, 2003

Pedro,

Try

Application.Run "Book2!MacroName"

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

Making a macro only work on certain files	2	Nov 11, 2022
How to call module function or sub from the Add In?	3	Feb 21, 2014
Excel 2003 - VBA to get a list of Module names in the project	4	Dec 19, 2012
Reading codelines?	3	Oct 26, 2013
Calling a Sub created on the fly	1	Nov 23, 2011
No data from another macro in another module	2	Mar 10, 2012
Program Question for Dave peterson	2	Feb 8, 2010
Call module	2	Apr 10, 2009

Ask a Question