save a file with a predetermined date in VBA
Y'ello. I want to create a macro that will save a document with a predetermined day of the week (always the next Saturday) in the title, e.g.
If I were to save the file today the macro would call the document "2013-03-29 Expense Reimbursement"
I know, and thank, MACROPOD for the calculated date formula that accomplishes this in a form field, but I want to do it in VBA for a Macro button.
The "only" piece I'm missing is the bit that would generate the date (I know how to choose a file location and add "Expense Reimbursement" to the title).
|