How to add Time & Date details in file name using VBA

I am creating an Excel spreadsheet Master, that will eventually save the Master Sheet as a new Excel spreadsheet along with a Word report. How can I add the Time and Date fields to the Excel and Word file names from within my SaveAs VBA code run within Excel?

Please Login or Register  to view this content.

You can use a version of this to save it something like "Temp 065417"

Please Login or Register  to view this content.

Hutch

Many thanks for your reply. Would this apply to a MS Word document too e.g. ext .doc?

Also Do I assume I will need to add the following to the start of my VBA string?
Dim strDate As String
Dim strTime As String
Dim strFilename As String
strDate = Format((Date), "MMMM d yyyy")
strTime = Format((Time), " hhmmss")

Sorry I am still getting back into VBA from a great deal of time off!!!!

Alan - There are no variables that need to be declared in the code I provided. It just adds the current time to the filename, (Now), formatted as "hhmmss".

Sorry,but I don't know what would need to be changed to make this work on a Word file. You'll need help from someone better than me for that.

Best of luck.