macro in Project

D

Danno

I use a macro in Excel to place the current date in the active cell with a
key combo. I want to use this in Project to enter dates in Actual Start and
Actual Finish, but the code needs modified. Can you please assist?
Excel code = ActiveCell.Value=Date
 
J

Jim Aksel

Not so sure why you would want to do that, the tracking toolbar already has a
form where you can enter the Actual dates.

If you want a macro... you need to be looking at a task. Assuming you have
a specific task selected, here is the line you need:

UpdateTasks ActualStart:=activeproject.CurrentDate

It should work for all selected tasks.

FYI - Since these are developer type questions, you should post to
micosoft.public.project.developer

--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com
 
D

Danno

Thanks for the suggestions. I really appreciate all the help I've gained
from searching the discussion groups in the past also. Kudos.
 
J

Jack Dahlgren MVP

Danno,

Did you know that in Excel there is a built-in shortcut for what you are
doing?

CTRL+; enters the current date
CTRL+: enters the current time

There is no equivalent function in project, but the date picker in project
defaults to current date.

-Jack Dahlgren
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top