View Single Post
 
Old 03-23-2014, 06:59 AM
lingering lingering is offline Windows 8 Office 2013
Novice
 
Join Date: Mar 2014
Posts: 1
lingering is on a distinguished road
Default 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).
Reply With Quote