VBA to return date created

Hi,

I found this code that copies the data from workbooks in a folder and pastes the data onto a master sheet. The code works fine but I also need to return the date the original workbooks were created(or the file name as it contains the date created) in each row of the master sheet containing data. Ideally the code would add a new column to the master sheet and place the date corresponding to the sheet the data was coppied from in each row. I have attatched the code below. Could someone please advise me on how to accomplish this.

Thanks

Hello Gtree,

Here is the code to return the file creation date. I don't have a good sense of what you want to with information on the spreadseet. That's why it isn't added into your macro.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Thanks I wasn't familiar with those commands I should be able to make that work.