Good morning.
I have a DESTINATION workbook with macros that pulls raw data from separate SOURCE files/workbooks. The source files/workbooks are updated daily (each time receiving a new date and time in the file name), and it's important for me to insert a date and time stamp on the destination book, so that I can track the specific source file that the macros are using. My macro automatically prompts the user to select a specific source file for use with the macros. Is there a way to insert the date and time from the chosen source file?
Thank you, in advance.
Bookmarks