declare your date macro as
public sub datemacro()
and then call this macro within your code of the other macro.

jnewl Wrote:
i have a macro where i create literals based on a date scheme.

i want to use that in several other macros and not key the code each
time
because if i have to make a change, i have to go to 20 programs. these
programs generate month end reports that have a date literal as part of
the
heading.

how do i include the 'date macro' in the others and then continue with
the
processing of the macro that now has the datemacro embedded.

i was looking for an include statement but do not find.

thanks


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=521904