Date References to save files using VBA Code

[mrmmickle1]

Is there an easy way to save a file with todays date?

For Example Customer Service Report "&Date&" or something to that effect "Today()" but in code where it would make the file unique?

[snb]

Sub M_snb()
thisworkbook.saveas "G:\OF\voorbeeld_" & format(date,"ddmmyyyy") & ".xlsx",51
End Sub

[mrmmickle1]

snb,

Thank you again! I am learning slowly but surely. I appreciate the help.

The 51 specifies .xlsx format correct?

-Matt

[snb]

Yes, you do !

Ckeck that in the VBEditor's help files, lemma saveas / fileformat