How to create a macro

[Guest]

I need to create a macro where it shows how much time I've been spending on
each project. I have #'s totaled up but have no idea on how to start the
macro. Any help would be much appreciated.

 

[NickHK]

Buccaneer,
If you look at the File > Prpoerties, there is a value of "Total Editting
Time". May be you can use that.

NickHK

 

[Norman Jones]

Hi Nick,

Unlike Word. I do not believe that this property is available in Excel.

 

[Myrna Larson]

I see it listed on a workbook that I've been using for at least 15 years
(since Excel 2.1), but it has no value.

 

[NickHK]

Norman,
I must say that I've never used it, just saw that it was there. You could
well be right, as I now see that its entry is blank.
Oh well.

NickHk

 

[NickHK]

Buccaneer,
As my first suggestion seems invalid, you might want to use AutoOpen and
_OnClose event to recalculate the the time the WB has been open this time,
adding that to the previous total.

NickHK

 

[Norman Jones]

Hi Myrna,

I see it listed on a workbook that I've been using for at least 15 years
(since Excel 2.1), but it has no value.

The property is listed and whilst it is possible to assign a value to it,
Excel does not.

I did not intend to deny existence of the property, but rather to query its
utility for the advocated purpose.

 

[Tom Ogilvy]

All the built in document properties are defined/available in all Office
files. However, individual office applications only maintain a subset of
those properties. As Norman stated, word maintains "total editing time"
while excel does. not. As another example, xl97 didn't maintain Last Save
Time, but xl2000 and later do. So if you open a file in xl97 that has been
opened previously in xl2000 or later, it looks like the value is being
maintained, but saving in xl97 does not update the value. (just an
interesting quirk).

As Norman said, you can write code to update the value in the built in
document property is you wish.

 

[Gord Dibben]

My thought was that the "total editing time" was updated only if the workbook
was shared.

I do not have any shared workbooks so have not tested this hypothesis.

Gord Dibben Excel MVP

 

[Norman Jones]

Hi Gord,

Microsoft Knowledge Base Article - 214393
XL2000: Revision Number and Total Editing Time Boxes Are Empty

XL2000: Revision Number and Total Editing Time Boxes Are Empty

Applies To
This article was previously published under Q214393
SYMPTOMS
On the Statistics tab of the Properties dialog box (click Properties on the
File menu) the Revision number and Total editing time boxes are blank.
CAUSE
This behavior occurs because Microsoft Excel does not use either of these
statistics.
MORE INFORMATION
The Properties dialog box is shared by Microsoft Office programs. Some
Microsoft Office programs use the Revision number and Total editing time
boxes; however, Microsoft Excel does not use either of these boxes.

For the full article see:

http://tinyurl.com/4ssd3

 

[Gord Dibben]

Thanks for the update and links Norman.

Learn new stuff every day<g>

Gord