How to create a macro
 

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.

How to create a macro
 

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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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.

On Tue, 28 Sep 2004 03:11:42 +0100, "Norman Jones"
wrote:

Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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

"Norman Jones" wrote in message
...
Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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.

---
Regards,
Norman


"Myrna Larson" wrote in message
...
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.

On Tue, 28 Sep 2004 03:11:42 +0100, "Norman Jones"
wrote:

Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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.

--
Regards,
Tom Ogilvy



"Norman Jones" wrote in message
...
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.

---
Regards,
Norman


"Myrna Larson" wrote in message
...
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.

On Tue, 28 Sep 2004 03:11:42 +0100, "Norman Jones"
wrote:

Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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

On Tue, 28 Sep 2004 11:38:19 +0800, "NickHK" wrote:

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

"Norman Jones" wrote in message
...
Hi Nick,

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

---
Regards,
Norman



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

NickHK

"Buccaneer" wrote in message
...
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.

How to create a macro
 

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


---
Regards,
Norman


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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.

How to create a macro
 

Thanks for the update and links Norman.

Learn new stuff every day<g

Gord

On Tue, 28 Sep 2004 18:24:14 +0100, "Norman Jones"
wrote:

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


---
Regards,
Norman


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
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.