How to call an external Excel macro.

[cr113]

Is there a way to call an Excel macro located in another Excel file?
I'm trying to create a common library of subroutines.

I'm using Excel 2007.

 

[Mike S]

Is there a way to call an Excel macro located in another Excel file?
I'm trying to create a common library of subroutines.

I'm using Excel 2007.

Will either of these approaches work for you?

http://www.mrexcel.com/forum/showthread.php?t=45948
http://www.fontstuff.com/vba/vbatut03.htm

http://www.mvps.org/dmcritchie/excel/install.htm