Storing the file creation date in a cell

[BajanPOET]

I would like to store the date a purchase order is generated in a spreadsheet. I was trying to use this code in the spreadsheet to store the date in cell E3

Worksheets("LPO").E3.Value = Date

but I was getting this error message:

Object doesn't support this property or method. What gives?

If I can get this to work, I will test the value of E3 using an IF statement. If E3 is blank, store the current date. If E3 already has a date, leave that date intact.

What? Who? ME????

 

[PHV]

Try this:
yourWorkbookObject.Worksheets("LPO").Range("E3").Value = Date

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886