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?
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?
Using Excel 2010
Code:Sub M_snb() thisworkbook.saveas "G:\OF\voorbeeld_" & format(date,"ddmmyyyy") & ".xlsx",51 End Sub
snb,
Thank you again! I am learning slowly but surely. I appreciate the help.
The 51 specifies .xlsx format correct?
-Matt
Using Excel 2010
Yes, you do !
Ckeck that in the VBEditor's help files, lemma saveas / fileformat
Bookmarks