marco variables or substitution
 

To add a note. Don't use Date. It's a VBA reserve word.
a=date 'today

--

John

johnf202 at hotmail dot com


"Tim Gwynn" wrote in message
...
I have a macro that references a month in a file name - it
is in multiple locations in the macro and I want to add an
entry at the beginning of the macro that allows for the
month number to substitute throughout the macro. I know
how to do this in SAS but I have not been able to find a
way to do it in Visual Basic.

For example

Date = 12

filename "date_03_analysis" so everywhere the date is
referenced it would substitute 12 instead of the word date.

Thank you.