<div>
You should be able to assign the value of the cell you want to <br />
<br />
ActiveWorkbook.BuiltinDocu<wbr />mentProper<wbr />ties(&quot;Crea<wbr />tion Date&quot;)<br />
<br />
You can do this with VBA<br />

</div>


You should be able to assign the value of the cell you want to

ActiveWorkbook.BuiltinDocumentProperties("Creation Date")

You can do this with VBA


<div>
Sorry for delay, it's been a busy day...<br />
<br />
Thanks CaptainKenbo, though not quite what I was after, I'll keep the code for future reference..<br />
<br />
brettdj, ..that's excellent, and thankyou for the added explanations<br />
Only problem is that the date is incorrect, I'm sure there must be a simple fix<br />
ie todays date comes out as 07-Aug-2001<br />
Can you please help..<br />
Thanks<br />
Des
</div>


Sorry for delay, it's been a busy day...

Thanks CaptainKenbo, though not quite what I was after, I'll keep the code for future reference..

brettdj, ..that's excellent, and thankyou for the added explanations
Only problem is that the date is incorrect, I'm sure there must be a simple fix
ie todays date comes out as 07-Aug-2001
Can you please help..
Thanks
Des

<div>
Thanks brettdj<br />
Really good!!!!<br />
My problem was with the formatting in the original files.<br />
If I can't work it out I'll post another question<br />
Thanks for your help, excellent<br />
Des
</div>


Thanks brettdj
Really good!!!!
My problem was with the formatting in the original files.
If I can't work it out I'll post another question
Thanks for your help, excellent
Des

<div>
<div class="content wysiwyg-content">
I have a folder with many Excel workbook files, 2003 version, in each.<br />
Each workbook file has the same format and the same two worksheet names.<br />
One worksheet has a cell with a date in it.<br />
Is it possible to write a macro in a new Excel file that will identify the creation date of each file within the folder and change the cell value within each of the files to the date that the file was created?
</div>
</div>


I have a folder with many Excel workbook files, 2003 version, in each.
Each workbook file has the same format and the same two worksheet names.
One worksheet has a cell with a date in it.
Is it possible to write a macro in a new Excel file that will identify the creation date of each file within the folder and change the cell value within each of the files to the date that the file was created?

Is it possible to change a cell to the creation date value of each xls file in a folder?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.