asked on what is the syntax to show todays date in vb?
hi Guys, I have a macro which send out an email from in Excel and attaches a PDF. code is
.Attachments. Add "\\zebra\Report Template_20220215\Report_2
How do tweak the dates in the code so it changes everyday ? Is it needs to be Today -1 in this format ("YYYYMMDD")
.Attachments. Add "\\zebra\Report Template_20220215\Report_2
How do tweak the dates in the code so it changes everyday ? Is it needs to be Today -1 in this format ("YYYYMMDD")
Microsoft ExcelMicrosoft Office
Last Comment
Justin Smith
ASKER
what is the new code then?
.Attachments. Add ""\\zebra\Report Template_" & Format$(Now() - 1, "YYYYMMDD") & "\Report_" & Format$(Now() - 1, "YYYYMMDD" ?
.Attachments. Add ""\\zebra\Report Template_" & Format$(Now() - 1, "YYYYMMDD") & "\Report_" & Format$(Now() - 1, "YYYYMMDD" ?
ASKER
do I have to Dim any variable?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I just run the path in the immediate window and it does not show the date at all. do I have to Dim strdate as date, string or something else?
ASKER
in the immediate window it's showing the path as "\\zebra\Report Template_\Report
ASKER
thanks very much for your help!
Now is a serial number which counts each da beginning at 01.01.1900, so if you substract 1 you get the date from yesterday.
This should deliver the date sequence you can add to your path / filename