FileDateTime - referencing THISworkbook not ACTIVEworkbook

[Quint6778]

Hello!

Im trying to get the 'last modified/created' time/date from a file i'm opening, but it keeps referencing the Macro workbook's date/time info instead.
Basically, its set up to allow the user to select their file from their folder... followed by this (which all works, except for FileDateTime()

Please Login or Register  to view this content.

....so im confused why "activeworkbook' is working for everything else except my FileDateTime() ??? Thanks in advance!

[xlnitwit]

You need the file name, not just the path. Perhaps use FileDateTime(FName) instead.

[Quint6778]

oh geez, that was it. it made sense immediately when you pointed it out. THANK YOU VERY MUCH!