I'm not sure what exactly you mean by "insert the template to my current workbook" (you
mean copy it from somewhere & paste it into the current Wb?) but here are a few ways to get
the current date.
In a cell somewhere (I would imagine in your Template Wb) you can use the formula: =TODAY()
Bear in mind that this must be copied & PasteSpecial'ed as Value or it will update to the
current date whenever the Wb gets opened.
Another option might be to use vba at some point, in which you could use:
Sheets("Sheet1").Range("A1").Value = Date
This will insert the date as a static value which will not update in the future once it's entered.
Corrected a couple bonehead typos.
Hey Smitty! How's things?
"ActiveCell = Date" enters the date when you run the macro and it will not automatically update to new date later. I use it alot so have it associated with a toolbar button and copied/pasted the equivalent icon from Word. But to automate it, try simply adding code to select the appropriate cell and then the above to your current code...
Didn't notice that you stressed a March 14 format... IF the template is already formatted that way and it doesn't translate that way when you paste it in to the new sheet, you need to add one more line of code.
ActiveCell = Date
Selection.NumberFormat = "mmmm d"
The object of interest (in this case the range D3) seldom if ever really needs to be activated
or selected in your code. (Code will run smoother & faster if we don't select/activate
the objects, but just refer to them instead.)
.Value = Date
.NumberFormat = "mmmm d"