Explorer's "Date Created" in an excel cell

[oneyejack77]

Is there any VBA that can automatically populate the Windows Explorer "Date Created" into an excel cell and not the created date off the file? You can see in the screen shot these are two different dates. I need a static date to run formulas off of for this report that will be archived. I don't want to manually enter it every time I run the report. Every day I run the report, the date that I saved that version is the date I need static.

Thanks

New Bitmap Image.png

[cebalaw]

This function should work (I added the format function to trim the time, remove if you are looking to include):

Please Login or Register  to view this content.

[oneyejack77]

Sorry I'm a novice with VBA. Your note said include the path and extension in the passed filename. Does this mean that I would have to edit my VBA with a new path and extension every time I save the file?

I'm using a workbook basically as a template. After I update it, I save it with a new name each day. Also, I didn't notice any cell references in the VBA above. How do I know what cell the date will be displayed in?

[cebalaw]

Create a module in the Visual basic Editor, then add the above mentioned procedure. Then you can get the creation date in any cell, like you would any Excel function, by typing =CreatedDate(filename). If you want to populate the current workbook, then use this function instead (always the current):

Please Login or Register  to view this content.

[oneyejack77]

Perfect! Thanks you very much!