CODEWITHSUNDEEP
excelvba
mongoose00318
mongoose00318

Reputation: 131

Excel/VBA File Creation Date

When creating a new file using VBA like so...

FileCopy "\\JACKSONVILLE-DC\Common\SOP's for JV\SOP Audits\SOP Audit Checklist-Template.xlsx", _
         "\\JACKSONVILLE-DC\Common\SOP's for JV\SOP Audits\2019\" & NewAuditFileName

Where is the system pulling the date/time to tell Windows when the file was created? Currently, for a file created yesterday (7/31/19) it shows the Date Created in Windows as 3/19/2019 with a Date Modified as 7/31/2019.

Upvotes: 0

Views: 205

Answers (1)

user11509084
user11509084

Reputation:

When you do this it is essentially the same as copying and pasting in Windows Explorer.

Therefore the Created and Modified dates will be those of the source file.

Upvotes: 1

Related Questions