| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date(Year,Month,Day) not returnign correct date | Excel Discussion (Misc queries) | |||
| How do I create a CORRECT histogram? | Charts and Charting in Excel | |||
| Find date, create new workbook, copy lines with same dates in column H | Excel Programming | |||
| Workbook Create Date fx | Excel Worksheet Functions | |||
Hybrid Mode
