Can't get correct Workbook Create date from VBA
 

Hi,
I'm trying to get the correct file creation date from an open,active excel
workbook.

When I go to File\Properties\General tab, it shows it was created March 18,
2008.
When I go to File\Properties\Statistics tab, it shows it was created October
14, 1996.

When I use this command:
fileDate = ActiveWorkbook.BuiltinDocumentProperties(11)

I get this result:
"10/14/1996 7:33:28 PM"

I am really trying to get the date on the General Tab.
So I'm really stumped as to what's going on.

Any ideas?

Thanks MikeZz

Can't get correct Workbook Create date from VBA
 

This might help:

http://www.j-walk.com/ss/excel/tips/tip57.htm


HTH,
JP

On Mar 19, 2:59*pm, MikeZz wrote:
Hi,
I'm trying to get the correct file creation date from an open,active excel
workbook.

When I go to File\Properties\General tab, it shows it was created March 18,
2008.
When I go to File\Properties\Statistics tab, it shows it was created October
14, 1996.

When I use this command:
fileDate = ActiveWorkbook.BuiltinDocumentProperties(11)

I get this result:
"10/14/1996 *7:33:28 PM"

I am really trying to get the date on the General Tab.
So I'm really stumped as to what's going on.

Any ideas?

Thanks MikeZz