I'm having an issue where opening a workbook though a VBA macro opens a different version of the file compared to when the same file is opened through Windows Explorer. The file I'm trying to open is a log on a network drive containing various data as well as a timestamp.
I've noticed that when opening through VBA, the log is only updated through the "Last Modified" date. However, when I open the same file through Windows Explorer there is data more recent than the "Last Modified" date. I am trying to figure out why the "Last Modifed" date is wrong in the first place, and why this results in my VBA macro opening an older version of the file.
I have confirmed that the filepath and filename are identical.