VBA or Function - Accessing file with changing name
Posted on 2013-10-14
I have a report that is created daily at 5 am, The source file naming convention is filename date (YYYY-MM-DD) Timestamp (hh-mm-ss) - ISS 2013-10-14-05-05-41.xls. Outside of the date change the other variables on the file name are going to be the minutes and seconds.
My goal is have update a data file that is linked to the source file by vlookup to update based on the most current source file in the folder. I would like the update to occur on a closed file as well. Is this possible? Could it be done with a function or would it need to be VBA?