Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update to Status date VBA

Status
Not open for further replies.
Palmcrest

Palmcrest

Technical User
Jul 10, 2006
66
AU
So when I record a macro to update the progress of a task to the status date I get something like this
< UpdateProject All:=False, UpdateDate:="3/02/19 11:00 AM", Action:=1>
I want to change the <UpdateDate:="3/02/19 11:00 AM"> to reference the Status Date

Te object browser suggests <.SpreadPercentCompleteToStatusDate = True>
When I use this nothing happens.
Has someone been down this track and would be able to help me with a starting point?
Thanks
 
Status
Not open for further replies.

Similar threads

thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
283
combo
combo
Andrzejek
  • Question
Outlook VBA - Trust access
Replies
3
Views
403
hermanlaksko
hermanlaksko
SLW89
  • Locked
  • Question
VBA newbie needs help
Replies
4
Views
271
Andrzejek
Andrzejek
xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
210
strongm
strongm
aldi07
  • Locked
  • Question
update a front-end databases with a new release using vba
Replies
2
Views
129
aldi07
aldi07

Part and Inventory Search

Sponsor

Back
Top