Excel/VBA File Creation Date

Question

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.

user11509084 · Accepted Answer · 2019-08-01 13:36:04Z

1

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.

answered Aug 1, 2019 at 13:36

user11509084

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel/VBA File Creation Date

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related