Excel Macro Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

william_rollins@hotmail.com - 12 Apr 2007 02:37 GMT

Hi All,

I'm dealing with an Excel issue that's driving me crazy and I was
hoping someone could help me out with.

I'm working on a spreadsheet to track projects and I would like to
create a macro that would track and show the number of a days a
project has been opened for each time the spreadsheet is viewed or
opened.

If anyone can offer any assistance, I would greatly appreciate it!

-Tommy

Reply to this Message

JE McGimpsey - 12 Apr 2007 03:17 GMT

Any reason you can't use a formula? Perhaps something like

=TODAY()-A1

where A1 contains the date the project opened?

> Hi All,
>
[quoted text clipped - 9 lines]
>
> -Tommy

Reply to this Message

william_rollins@hotmail.com - 12 Apr 2007 12:41 GMT

> Any reason you can't use a formula? Perhaps something like
>
[quoted text clipped - 20 lines]
>
> - Show quoted text -

I wish I could just use a formula but unfortunately I must use a macro
so everytime the page is viewed or opened "whether it's today or next
week". My spreadsheet will automatically show the number of days a
project has been opened.

Reply to this Message

JE McGimpsey - 13 Apr 2007 03:55 GMT

Since TODAY() is a volatile function, that formula will recalculate
whenever the sheet is opened or any other calculation occurs.

So I don't understand what you see the macro doing differently...

For instance, what should trigger the macro to recalculate (other than a
sheet calc or opening the file)?

> I wish I could just use a formula but unfortunately I must use a macro
> so everytime the page is viewed or opened "whether it's today or next
> week". My spreadsheet will automatically show the number of days a
> project has been opened.

Reply to this Message

Rate this thread: