I have a macro that opens a file using variables T1 & T2, which give me the current year and current month, ex. filename: \MyDocs\%T1%\%T2%\%T2% MTD Stats.xls, which would be for this month, \MyDocs\2008\JANUARY\January MTD Stats.xls. This works fine for every day of the month except for the first day of the next month. I need it to pull the previous month if it is the first day of the next month. So, for instance on February 1st, will need it to pull \MyDocs\2008\January\January MTD Stats.xls. Is there a way to do this? Am new to Macro Express, so not certain how this would be achieved??? Any help would be appreciated!
This is what I have so far:
<MACRUN2:DATE - current year YYYY>
<MACRUN2:DATE - current MONTH Mmmmm>
<LAUNCHDEL2:0:01H:\MyDocs\%T1%\%T2%\%T2% MTD Stats.xls>