Project VBA: How and Why it can Make You a Project Guru! - PowerPoint PPT Presentation

Project vba how and why it can make you a project guru l.jpg
Download
1 / 14

Project VBA: How and Why it can Make You a Project Guru!. Rod Gill Founder ACE Project Systems Ltd. A Project Guru is not just a power user Project Gurus are great at managing and reporting on, project information

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Presentation

Project VBA: How and Why it can Make You a Project Guru!

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Project vba how and why it can make you a project guru l.jpg

Project VBA: How and Why it can Make You a Project Guru!

Rod Gill

Founder

ACE Project Systems Ltd


Slide2 l.jpg

A Project Guru is not just a power user

Project Gurus are great at managing and reporting on, project information

Data management and reporting is what makes VBA so useful and productive


Rod gill l.jpg

Rod Gill

  • Microsoft MVP for Project since 1997(Most Valuable Professional)

  • Has over 25 years experience as a Project Manager in Construction, Software Engineering and many other industries in between

  • Trains Project Management and advanced Microsoft Project courses

  • Author of the book: VBA Programming for Microsoft Office Project Versions 98 through 2007


Slide4 l.jpg

A Project Guru is not just a power user

Project Gurus are great at managing and reporting on, project information

Data management and reporting is what makes VBA so useful and productive


This session is about how vba helps you l.jpg

This Session is aboutHow VBA helps you:

  • Manipulate data

  • Import/Export data

  • Create custom Reports in Excel

  • Add functionality to Project

  • Make you stand out as an expert

  • Make you more money!

  • Up skill you to more job security


You ll learn l.jpg

You’ll Learn

  • How Project VBA will help elevate you to Guru status

  • Lessons from some real life examples

  • Some code to get you going

  • A road map to success with Project VBA


How project vba will help elevate you to guru status l.jpg

How Project VBA will help elevate you to Guru status

  • Helps you understand and use your application better

  • Makes you and your team more productive

  • Adds value to your information

  • Eliminates boring and repetitive work

  • Makes following processes easier and more reliable

  • Makes you more useful and valuable at work

  • Makes you stand out as a Power User/Guru


Vba more benefits l.jpg

VBA – More Benefits

  • If you know Project VBA, Excel VBA is easy to pick up

  • Lets you integrate the power of Project and Excel almost seamlessly

  • Good schedulers likely to have the right aptitude to program in VBA

  • Can be used for any active project

  • Works with or without Project Server

  • VBA written for Project 98 still works in Project 2010 – so great compatibility


Real life lessons from two projects l.jpg

Real Life Lessons from Two Projects

  • Multi-company, multi-country, multiple programs of projects - outsourcing project

  • Refinery upgrade


Examples l.jpg

Examples

  • When more than one person needs to use the same file:A Project_Open event shows the View and Table reserved for the logged in user.

  • Getting Project to automatically scroll a project to today’s date on opening

  • Detailed graphs required weekly by Contractor, Discipline and Construction LocationInformation sent to Excel and graphed


Examples11 l.jpg

Examples

  • Weekly report takes an hour to fill in each weekRead Project Server Data into Excel to create 80% of the report in seconds, even when that data is half way around the world

  • Spreadsheet holds useful progress dataUpdate a schedule with data from Excel

  • Manipulate Task names to save time and effort

  • Reports print differently each weekCreate macros to guarantee correct formatting of printed reports (no project Server)


When is it worth coding l.jpg

When is it Worth Coding?

  • I write code when to do so will take 50% less time than doing it manually (including repetitions)

  • I write code to replace a boring job!

  • The more working code I have the more I have to copy and edit and the less time it takes!


Road map to learn project vba l.jpg

Road map to LearnProject VBA

  • Get my Book!

  • Learn to record macros

  • Learn to edit recorded macros

  • Learn basic loops for Tasks, Assignments

  • Develop code that’s easy to maintain

  • Develop code to work with Excel/databases

  • Write Add-ins

  • Microsoft News Groups to keep you going

  • http://msdn.microsoft.com/project/ for the Project Developer Center


Finally l.jpg

Finally

  • I’ll be at the MSProjectExperts stand in the Exhibitors Hall

  • Get THE Project VBA book

  • Chris Boyd sessions: Project Client Advanced Development Using VSTO and Project 2010 - Programmability

  • Have a go!

    Rod Gill

    rodg@project-systems.co.nz

    http://www.projectvbabook.com


  • Login