Venture VBA: How and Why it can Make You a Task Master!.


62 views
Uploaded on:
Description
Trains Project Management and progressed Microsoft Project courses ... without Project Server. VBA composed for Project 98 still works in. Venture 2010 so extraordinary ...
Transcripts
Slide 1

Venture VBA: How and Why it can Make You a Project Guru! Bar Gill Founder ACE Project Systems Ltd

Slide 2

A Project Guru is not only an influence client Project Gurus are awesome at overseeing and giving an account of, undertaking Data administration and reporting is the thing that makes VBA so valuable and gainful

Slide 3

Rod Gill Microsoft MVP for Project since 1997 (Most Valuable Professional) Has more than 25 years experience as a Project Manager in Construction, Software Engineering and numerous different businesses in the middle of Trains Project Management and progressed Microsoft Project courses Author of the book: VBA Programming for Microsoft Office Project Versions 98 through 2007

Slide 4

A Project Guru is not only an influence client Project Gurus are extraordinary at overseeing and covering, venture Data administration and reporting is the thing that makes VBA so helpful and beneficial

Slide 5

This Session is about How VBA helps you: Manipulate information Import/Export information Create custom Reports in Excel Add usefulness to Project Make you emerge as a specialist Make you more cash! Up ability you to more professional stability

Slide 6

You\'ll Learn How Project VBA will hoist you to Guru status Lessons from some genuine illustrations Some code to make them go A guide to accomplishment with Project VBA

Slide 7

How Project VBA will raise you to Guru status Helps you comprehend and utilize your application better Makes you and your group more profitable Adds quality to your data Eliminates exhausting and tedious work Makes taking after procedures simpler and more dependable Makes you more valuable and important at work Makes you emerge as a Power User/Guru

Slide 8

VBA – More Benefits If you know Project VBA, Excel VBA is anything but difficult to get Lets you coordinate the force of Project and Excel consistently Good schedulers prone to have the right fitness to program in VBA Can be utilized for any dynamic task Works with or without Project Server VBA composed for Project 98 still works in Project 2010 – so incredible similarity

Slide 9

Real Life Lessons from Two Projects Multi-organization, multi-nation, different projects of ventures - outsourcing venture Refinery update

Slide 10

Examples When more than one individual needs to utilize the same record: A Project_Open occasion demonstrates the View and Table saved for the signed in client. Getting Project to consequently look over a venture to today\'s date on opening Detailed diagrams required week after week by Contractor, Discipline and Construction Location Information sent to Excel and charted

Slide 11

Examples Weekly report takes a hour to fill in every week Read Project Server Data into Excel to make 80% of the report in seconds, notwithstanding when that information is most of the way around the globe Spreadsheet holds helpful advancement information Update a timetable with information from Excel Manipulate Task names to spare time and exertion Reports print contrastingly every week Create macros to ensure right organizing of printed reports (no undertaking Server)

Slide 12

When is it Worth Coding? I compose code when to do as such will take half less time than doing it physically (counting reiterations) I compose code to supplant an exhausting occupation! The additionally working code I have the more I need to duplicate and alter and the less time it takes!

Slide 13

Road guide to Learn Project VBA Get my Book! Figure out how to record macros Learn to alter recorded macros Learn essential circles for Tasks, Assignments Develop code that is anything but difficult to keep up Develop code to work with Excel/databases Write Add-ins Microsoft News Groups to keep you going http://msdn.microsoft.com/venture/for the Project Developer Center

Slide 14

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! Bar Gill rodg@project-systems.co.nz http://www.projectvbabook.com

Recommended
View more...