Creating a Project with VBA (MS Project 2003 Pro)?

[Steve Tennison]

We are currently using Peoplesoft Projects and trying to integrate the data
in Peoplesoft to MS Project. There seems to be problems with the delivered
code and not much help from the Peoplesoft Community. My thought is to use
VBA and access the Oracle data thereby creating the project, tasks, start/end
dates, etc. I can't find anything anywhere that basically shows this sort of
a thing. I would appreciate any help/direction. I have even looked through
several books and can't find much on the VBA side of MS Projects.

 

[John]

We are currently using Peoplesoft Projects and trying to integrate the data
in Peoplesoft to MS Project. There seems to be problems with the delivered
code and not much help from the Peoplesoft Community. My thought is to use
VBA and access the Oracle data thereby creating the project, tasks, start/end
dates, etc. I can't find anything anywhere that basically shows this sort of
a thing. I would appreciate any help/direction. I have even looked through
several books and can't find much on the VBA side of MS Projects.

Steve,
Maybe this will help. Go to our MVP website at:
http://www.mvps.org/project/links.htm
and look for the link at the bottom of the page for, "Project 98 Visual
Basic Environment Training Materials". Even though it says it is for
Project 98, it is equally applicable to all current versions of Project.
The only difference is that newer versions of Project have expanded the
object library.

For some good examples of VBA code, go to fellow MVP, Jack Dahlgren's
website at: http://masamiki.com/project/macros.htm
You may not find anything in Jack's examples for importing into Project,
but by studying his "Export hierarchy to Excel" macro, you basically
want to do something similar but in reverse.

Hope this helps.
John
Project MVP

 

[Steve Tennison]

Thanks John. However the problem I am having is creating the project from
scratch. I can't seem to find the objects.properties to do this. It just
may be a mental block but it just doesn't seem to click. I'm open to any
help, including books but I haven't found any good MS Project VBA Books with
any detail samples.

 

[John]

Thanks John. However the problem I am having is creating the project from
scratch. I can't seem to find the objects.properties to do this. It just
may be a mental block but it just doesn't seem to click. I'm open to any
help, including books but I haven't found any good MS Project VBA Books with
any detail samples.

Steve,
It almost appears you're trying to run before you learn to walk. The
link I suggested for learning Project based VBA is an excellent
tutorial. It is obviously very Project VBA oriented (unlike general
books on VB) and once you learn the basics of how to work with Project
objects, the rest will fall out.

If you simply want to know more about the Project Objects, look at the
Project object model which can be found in the Project VBA help file.

I suggest you check out my suggested references. Then if you have a
specific question, post again.

John
Project MVP

 

[JackD]

Also a number of examples with narrative of how things work can be found
here:

http://zo-d.com/blog/archives/programming.html