Project VBA Macro Development

Microsoft's Project for Windows is the most widely used project scheduling software available in the world today.  Rod Gill wrote the only book on Project VBA in the World and was asked to speak at the last Microsoft Project conference in Phoenix 2009 on advanced uses for Project VBA.

Project is a great tool for managing the information for your projects. Data management and reporting is what makes Project VBA so useful and productive.

If there is anything Project can't quite do that you need, it is very likely that a little Project VBA will meet your needs. You will be pleasantly surprised at how much can be achieved in just a few days.

Reasons for Project VBA development

  • You have a repetitive action such as printing the same list of reports in the same format. Automate the printing to save time.
  • You need to enforce data accuracy standards so develop a macro to check data is accurate and values are entered in custom fields.
  • You need to share data with other systems so a macro can read and write to databases, text files or other Office applications directly.
  • You want a custom report in Excel so write a VBA macro to export data from one or more projects to an Excel report.

Excel VBA macros can read data from one or more project files to create macros or share data.

If you need a more robust solution that needs to be rolled out to a lot of users, then we can convert VBA to VB add-ins.

It's more of a question of "What do I want to do?" rather than
"What can I do?"

Call Rod Gill to discuss your development needs on +64 21 623878

For some free code examples, click HERE