Hello all,
I was hoping that someone might be able to shed some light on a method to accomplish what I am trying to do. Any of your comments and suggestions would be appreciated.
What I need to do is take a Project .mss file, take the WBS task numbers and descriptions in it, compaire them to an Access data table (for updates), and then update the Access table with the new entries.
The basic code which I'm using to open the project .mss file and view the fields is the following: (Note: < > shows a generic representation and should not be taken literally)
Dim ProjObj As MSProject.Application
Set ProjObj = CreateObject("msproject.application")
ProjObj.FileOpen "C:\EVMS\" & GetFilename, _
ReadOnly:=False
ProjObj.Visible = True
Dim ActiveProject As MSProject.Project
Set ActiveProject = ProjObj.ActiveProject
Dim TaskProj As MSProject.Task
Dim <fieldvariablename>, <nextfieldvariablename>, ... As Variant
<fieldvariablename>= ActiveProject.Tasks(TaskProj.ID).<FieldName>
.
.
.
Question:
1. How do I equate a RecordSet value to the project Task field value? I want to be able to copy the Name, WBS, and Task Propertiy descriptions to RecordSet values, which will then update an Access table.
The following MS link gives good information regarding the mpp structure:
http://msdn.microsoft.com/library/d...-us/pjsdk/html/pjproTaskGroups_HV45316966.asp
2. As far as I can tell, to open the MSPRJ9.OLB Object Library File will require that Project be installed on the system in use. Is this correct? Apparently, either a registry key for MS Project is being queried or a .lib file that creates the license verification is being checked. Does anyone know how works for the msprj9.olb file? Can i still develop a Project to Access automation routine according to the EULA even though Project is not (yet) installed? Its depenency files are already on the local system, but I am getting a runtime 429 error.
I appreciate any help or information.
Thank you,
-David
I was hoping that someone might be able to shed some light on a method to accomplish what I am trying to do. Any of your comments and suggestions would be appreciated.
What I need to do is take a Project .mss file, take the WBS task numbers and descriptions in it, compaire them to an Access data table (for updates), and then update the Access table with the new entries.
The basic code which I'm using to open the project .mss file and view the fields is the following: (Note: < > shows a generic representation and should not be taken literally)
Dim ProjObj As MSProject.Application
Set ProjObj = CreateObject("msproject.application")
ProjObj.FileOpen "C:\EVMS\" & GetFilename, _
ReadOnly:=False
ProjObj.Visible = True
Dim ActiveProject As MSProject.Project
Set ActiveProject = ProjObj.ActiveProject
Dim TaskProj As MSProject.Task
Dim <fieldvariablename>, <nextfieldvariablename>, ... As Variant
<fieldvariablename>= ActiveProject.Tasks(TaskProj.ID).<FieldName>
.
.
.
Question:
1. How do I equate a RecordSet value to the project Task field value? I want to be able to copy the Name, WBS, and Task Propertiy descriptions to RecordSet values, which will then update an Access table.
The following MS link gives good information regarding the mpp structure:
http://msdn.microsoft.com/library/d...-us/pjsdk/html/pjproTaskGroups_HV45316966.asp
2. As far as I can tell, to open the MSPRJ9.OLB Object Library File will require that Project be installed on the system in use. Is this correct? Apparently, either a registry key for MS Project is being queried or a .lib file that creates the license verification is being checked. Does anyone know how works for the msprj9.olb file? Can i still develop a Project to Access automation routine according to the EULA even though Project is not (yet) installed? Its depenency files are already on the local system, but I am getting a runtime 429 error.
I appreciate any help or information.
Thank you,
-David
Last edited:
