C
chuck Slocter
I have a Time Sheet application written in MS Access. I need MS Access to
add Users hours worked for a tasks in MS Project.
Example
Joe enters in the Access Timesheet application that he worked on Task 1 for
2 hour on 8/1/06 and 3 hours on 8/3/06.
In access I can open MS project and view/edit Tasks.
Dim prjApp As MSProject.Application
Dim prjProject As MSProject.Project
Dim intTask As Integer
Set prjApp = CreateObject("Msproject.Application")
prjApp.FileOpen "c:\ProjectTracking.mpp", ReadOnly:=False
prjApp.Visible = True
Set prjProject = prjApp.ActiveProject
for x = 1 to prjProject.tasks.count
debug.Print prjProject.tasks(x).resourcenames
next x
I do not want to update the Tasks Actual Hours worked. I want to add an
entry that joe worked on different days.
Thanks
add Users hours worked for a tasks in MS Project.
Example
Joe enters in the Access Timesheet application that he worked on Task 1 for
2 hour on 8/1/06 and 3 hours on 8/3/06.
In access I can open MS project and view/edit Tasks.
Dim prjApp As MSProject.Application
Dim prjProject As MSProject.Project
Dim intTask As Integer
Set prjApp = CreateObject("Msproject.Application")
prjApp.FileOpen "c:\ProjectTracking.mpp", ReadOnly:=False
prjApp.Visible = True
Set prjProject = prjApp.ActiveProject
for x = 1 to prjProject.tasks.count
debug.Print prjProject.tasks(x).resourcenames
next x
I do not want to update the Tasks Actual Hours worked. I want to add an
entry that joe worked on different days.
Thanks