Hello everyone
I think i was misunderstood but anyway someone has just answered the same
without specifically asking for it, but thanks anyway, it's a wonderfull
grup
Audie
Here's The Answer i found and forgive my grammar
Syntax 1 and Syntax 2 assume that the macros are either in the same
WorkBook or that there is a Reference to the WorkBook containing the
macros.
To set a reference to another WorkBook : If the WorkBook containing
the macro to run is not open, open the WorkBook. Alt-F11 to access
VBE. Ctrl-R to activate Project Explorer. Select the project of the
macro that does the called. Tools > References. Check the name of the
project that contains the called macros.
Syntax 1
Call MacroName ' No parameters
Call MacroName (param1, param2) ' Parameters
Syntax 2
MacroName ' No parameters
MacroName param1, param2 ' Parameters
Syntax 3 assumes that the WorkBook contaning the called macros is
open, but that there are no References to that WorkBook.
Application.Run "'FileName.xls'!MacroName"
' No parameters
Application.Run "'FileName.xls'!MacroName", param1, param2
' Parameters
----------------------------------------------------------------------------
----------------------------------
Here are some WebSites that offer info on writing VBA code (aka
creating macros) :
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.mvps.org/dmcritchie/excel/excel.htm#tutorials
http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101
/default.asp
HTH
Paul
