Custom Fieldsand VBA 1

[WhtChoklat]

I was given the task of creating reports within Project. It was something that was started before I was hired. The problem is that the person who created the reports used all the Custom Fields that Project has and Management wants me to write the VBA in Project to run the code in the background so the custom fields are not needed.

I am new to project, and I don't know how it ticks. I need to know how to Run the VB in the background and how each column in the Report I am making will call the values that are generated by the VB. I hope someone can help me.

Ed Rich

 

[RonLeenders]

Ed,
There are many approaches to this, from modifying the MS Project database to add new data structures, through to using some external (to MS Project) data storage.

MS provides sample code on how to modify the MS Project Database (and extend your data model). See Developer Support article :

http://www.microsoft.com/downloads/...20-C4C4-4EAB-8188-15F5824D9CA0&displaylang=en

MS provides sample code on how to connect to a MS Access database from within Project, once you have included MS Access ActiveX Data Objects in your VBA References (Tools Menu). This is documented in the "MS Project Inside & Out" manual" (Part 10: Programming Custom Solutions). I don't know offhand how to get the code to you electronically, but read on...

MS also provides sample code on how to use Excel to format and report data (and hence you can guess the reverse), in the following article on the MS Web site:

http://www.microsoft.com/downloads/...69-ED3E-4DAB-8EFD-4BAE1B918EC3&displaylang=en

Regards
Ron

 

[WhtChoklat]

Ron,

Thanks for the help. I actually have the book that you recommended right in front of me! This was most helpful in my project.

Thanks,

Ed