Jump to content
Macro Express Forums

sueshe

Members
  • Posts

    5
  • Joined

  • Last visited

Everything posted by sueshe

  1. Thanks Cory! have put in place, so I'll see in the morning, since it's the first.... if it serves the purpose!!! Tasha
  2. 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>
  3. thank you for your help, I was able to take the macro on the other post and make it work finally!!! YAY!
  4. Thank you for your reply.....but won't this just give me the current date? I need the current months end date, for instance, this month it would be 013108, next month would be 022908, etc. quote name='James' date='Jan 25 2008, 11:50 AM' post='10019'] Not sure if this is what you are looking for, but the following generally works for me: 1. Go into Text Commands 2. Go into Date commands 3. Select the format you want and place it in a Variable 4. Enter a Text Type command where you want the date inserted and add the Variable from step 3 (ie <TEXTTYPE:<SPACE>(jr %T25%)> Hope this helps
  5. I am trying to create a macro that will type out the current month end date in MMDDYY format. I found the posting on this site that had the example macro for this, but it will not work on mine for some reason. Don't know if I am doing it wrong, or what, I am such a beginner at this. Can someone please help me with this? I am just learning, so be gentle. I do not have PGM Function library. I have Macro Express 3.7. Thanks so much for your help!
×
×
  • Create New...