Hi Guys,
I wanted to know if anybody tried to change the time stamp that comes from the file property ( myFile.DateCreated = 8/6/2012 12:20:15 AM ) to a number, similar to what excel cell will do id you change the cell property to ( General ) will give you a number like 41141.50 which correspond to the date and time.
I need this to select Excel sheets that was created after a certain date, EX:
if myFile.datecreated < 41121 Then GoTo SkipF
Thanks !
Bookmarks