correct statement to return time

[tryer]

I have the following code

Please Login or Register  to view this content.

which contains the workbook name, and date, the code opens a new workbook and saves it under this name. I would like to add the time to this so that if i later run the program again it will have a different filename (different time)
Can anyone help with the correct statement to return the time?

[JBeaucaire]

Does this do what you want:

Please Login or Register  to view this content.

[tryer]

Thank for the reply. nfortunately I get a compile error message saying expected seperator or ) with the . prior to xls highlighted, I cant see any missing brackets

[arthurbr]

Could it be there is a " missing?

Please Login or Register  to view this content.

[tryer]

Thanks Arthur your right there was a " missing. this code now works but I think I must be missing something it currently returns the day/date as 12-30-1899_0000.xls so presumably I have to pick up the system date and time from somewhere?

[shg]

If you'd like the the files to sort in date order,

Please Login or Register  to view this content.

[tryer]

Thanks Shg, that did it