Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Matilda Hughes   on Sep 07 In MS Office Category.

  
Question Answered By: Shaun Thomas   on Sep 07

You can use the format() function to define what part of the now()
function result you want to include. If you use the year -> seconds
order you can sort all files ascending by filename.

sTime = Format(Now(), "hhmmss")
sDateTime = Format(Now(), "yyyymmddhhmmss")

Share: 

 

This Question has 3 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on return time in seconds in VBA? Or get search suggestion and latest updates.


Tagged: