Date formatting

[Guest]

I've got a marco that automatically saves the file to include the quote and
business name. I.e. 1000 ACME.xls. I also need to add the current date
without formatting. I.e. 1000 (quote number) 160507(date) ACME (business
name).xls How can I get the date in this format for the macro?

 

[Jim Cone]

Use the Format function...
Format(Date,"ddmmyy")

(from one reference book: "It's possibly the most complex single function call in VB")
--
Jim Cone
San Francisco, USA


http://www.realezsites.com/bus/primitivesoftware
"JonathanW" <[email protected]>
wrote in message
I've got a marco that automatically saves the file to include the quote and
business name. I.e. 1000 ACME.xls. I also need to add the current date
without formatting. I.e. 1000 (quote number) 160507(date) ACME (business
name).xls How can I get the date in this format for the macro?