External file properties not updated - VBA

Question

I have a macro that reads out external file properties like date created. The file from where I read is stored on a server. Unfortunately the date returned is not the correct one when running the macro the first time. Only when I open the file or when I run the macro several times, the correct updated date created is returned.

Does anyone have an idea how to solve that issue except from opening the file or looping through until the date is correct?

Here is the code:

strFilename = "<FILENAME>"

Workbooks.Open strFilename
Workbooks("strFilename").Close

Set oFS = CreateObject("Scripting.FileSystemObject")

lastcreatedLTVfile = CDate(Format(oFS.GetFile(strFilename).DateCreated, "dd.mm.yyyy"))

Answer 1

Do you want DateCreated or do you actually want DateLastModified? In your question you say "correct updated date" so I guess you should be using DateLastModified.