Archive of Mr Excel Message Board
Back to Dates in Excel archive index
Back to archive home
create date as file namePosted by atom on June 22, 2001 8:46 AM
hi! it's not specific excel but should be at least a similiar routine as for word: I'd like to have a batch to save a file (or multiple files) with its creation date as filename. any scripting solutions? thanks!
Re: create date as file namePosted by Damon Ostrander on June 22, 2001 12:17 PM
This is easy to do, but you didn't mention what files you wanted to save, so I can't provide a specific solution. For example, do you want to rename all files in a given folder? All documents open in Word? Or perhaps just the currently active workbook in Excel? Anyway, whatever it is can be easily done.
To access the creation date of any office document, just use the BuiltinDocumentProperties Property. For example, to save the currently active Excel workbook named by its date:
d = BuiltinDocumentProperties("Creation Date")
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.