Total Editing Time/BuiltInDocumentProperties(13)

[Haukwa]

I discovered the BuiltinDocumentProperties(13) or Total Editing Time in
MS Word. Can anyone tell me if this property exists/works in Excel?

When I look at File\Properties\Statistics for a specific workboook, the
Total Editing Time field is empty. When I try to use
ActiveWorkbook.BuiltinDocumentProperties(13) I get an 'Automation
Error'. When I try to use other BuiltinDocumentProperties (subject or
author), I get the appropriate text. This leads me to believe that
BuiltinDocumentProperties exists/works, but that Total Editing Time
does not work.

Any help is appreciated.

Gerry

 

[Rowan Drummond]

It's not used in Excel.

See http://support.microsoft.com/default.aspx?scid=kb;en-us;214393

Regards
Rowan

 

[Haukwa]

Rown,

Thanks for the link, although the news is very disappointing. I'm
tasked with evaluating the impact of a new spreadsheet tool on
man-hours required to perform a specific task. I have been throwing
around phrases like '1000 man-hours saved because of my new VBA-driven
workbook'. Now they want to see proof. Without going back and redoing
the grossly wasteful hours of work, I was hoping to measure editing
time on old spreadsheets and compare them with new spreadsheets.

Oh well. I do plan on using the measuring technique on a new Word
project.

Thanks, again.

Gerry

 

[Rowan Drummond]

Hi Gerry

Sorry to be the bearer of bad news.

I guess you could use Workbook_open and Workbook_beforeClose events to
log (maybe on a hidden sheet) when the book was opened and closed.
Although I imagine it would be a lot harder to log how much time was
actually spent editing the file while it is open.

Regards
Rowan