How to sort all my excel/word files by original date created or saved?

I have few hundreds of word/excel files whose date modified and date created got mysteriously changed to the current date and time. The files were created in the last 10 years and I'm really breaking my head to figure how to sort them. Never followed a file naming or folder structure convention and now I'm paying the price for it. All I was doing was rearranging files and folders between drives and folders and now I'm stuck with this problem. I did the rearrangement so that I could setup dropbox and skydrive cloud sync.

Originally Posted by HaHoBe

Hi, slicksilver79,

have you looked up the BuiltinDocumentProperties to find out about the CreationDate and the DateLastSaved? If the information you need is found there you may use VBA to rename the files accordingly by something like

Please Login or Register  to view this content.

HTH,
Holger

Yes! It has the correction information. What's the best way to rename 100s of files using VBA(I'm a code newbie)? Thanks