book

Microsoft® Office Project 2003 Inside Out

Name: Microsoft® Office Project 2003 Inside Out
Author: Teresa S. Stover
ISBN: 9780735619586

by Teresa S. Stover

November 2003

Intermediate to advanced

1088 pages

32h 5m

English

Microsoft Press

Read now

Unlock full access

Microsoft® Office Project 2003 Inside Out
A Note Regarding Supplemental Files
Acknowledgments
We'd Like to Hear from You!
About the CD
What's on the CDUsing the CDSystem RequirementsSupport Information
Conventions and Features Used in This Book
Text ConventionDesign Conventions
About the Authors
1. Project Fundamentals
1. Introducing Microsoft Project 2003
Using this BookUsing Microsoft Project—An OverviewMicrosoft Project 2003 EditionsMicrosoft Project Server and Microsoft Project Web AccessWhat's New in Microsoft Project 2003What's New in Project Standard 2003Copying a Picture of ProjectReviewing Specific Types of Information Using the Project GuideWorking with COM Add-InsCollaborating with Your Workgroup via E-MailGetting Help and TrainingWhat's New in Project Professional 2003Specifying Multiple Traits for One ResourceSoft-Booking Proposed ResourcesProtecting Baseline InformationWhat's New in Project Server and Project Web Access 2003Collaborating with Team MembersManaging ResourcesManipulating Microsoft Project the Way You WantLearning As You GoGetting Started with Office OnlineWorking with the Project GuideGetting HelpSearch for a Specific TopicBrowsing Help ContentsGetting Help for Project FieldsGetting Help for Dialog BoxesSurfing the Web for Project AssistanceTeaching Yourself Microsoft Project and Project ManagementJoining Project CommunitiesFinding Project DownloadsSetting Your Preferences for Project AssistanceReporting CrashesWorking with Project Smart TagsWorking with the Sample Database
2. Understanding Projects and Project Management
Understanding Project Management BasicsWhat Is a Project?What Is Project Management?Understanding Project Management ProcessesPlanning the ProjectExecuting the ProjectControlling the ProjectClosing the ProjectFacilitating Your Project with Microsoft ProjectCreating a Model of Your ProjectWorking with Your Team through Microsoft ProjectUsing Microsoft Project in Your EnterpriseUnderstanding Project StakeholdersKeys to Successful Project Management

2. Developing the Project Plan
3. Starting a New Project
Focusing the Project VisionDefining ScopeUnderstanding Product Scope and Project ScopeDeveloping the Scope StatementCreating a New Project PlanCreating a Project FileCreating a New Project with a TemplateCreating a New Project from an Existing ProjectSaving Your New ProjectScheduling from a Start or Finish DateSetting Your Project CalendarWorking with Base Calendars in Microsoft ProjectApplying a Base Calendar to the Project CalendarAttaching Project DocumentationShowing the Project Summary TaskCopying a Document into Your Project FileHyperlinking a Document from Your Project FileEntering TasksAdding Tasks to Your Project PlanImporting Tasks from an Excel WorksheetEntering Recurring TasksSequencing and Organizing TasksMoving TasksInserting Additional TasksCopying TasksDeleting TasksOrganizing Tasks into an OutlineSetting Up Your Work Breakdown StructureUnderstanding Work Breakdown Structure CodesSetting Up Work Breakdown Structure CodesCharting Your WBS in VisioAdding Supplementary Information to Tasks
4. Viewing Project Information
Understanding Project Information CategoriesAccessing Your Project InformationUsing ViewsWorking with Gantt ChartsWorking with Network DiagramsWorking with Graph ViewsWorking with Sheet ViewsWorking with Usage ViewsWorking with FormsWorking with Combination ViewsWorking with TimescalesUsing TablesViews that Use TablesChanging the Table in a ViewModifying a TableUsing FieldsRearranging Your Project InformationSorting Project InformationGrouping Project InformationFiltering Project InformationArranging Your Microsoft Project WorkspaceSetting Your Default ViewShowing and Hiding Workspace ElementsSplitting a WindowSwitching Among Open ProjectsNavigating to a Specific Location in a View
5. Scheduling Tasks
Setting Task DurationsDeveloping Reliable Task DurationsUnderstanding Estimated vs. Confirmed DurationsEntering DurationsUnderstanding How Durations Affect SchedulingReviewing DurationsCalculating Your Most Probable DurationEstablishing Task DependenciesCreating the Finish-to-Start Task DependencyUnderstanding the Dependency TypesOverlapping Linked Tasks by Adding Lead TimeDelaying Linked Tasks by Adding Lag TimeChanging or Removing LinksReviewing Task DependenciesScheduling Tasks to Achieve Specific DatesUnderstanding Constraint TypesChanging ConstraintsWorking with Flexible and Inflexible ConstraintsFlexible ConstraintsModerately Flexible ConstraintsInflexible ConstraintsReviewing ConstraintsSetting Deadline RemindersCreating Milestones in Your ScheduleWorking with Task CalendarsCreating a Base CalendarAssigning a Base Calendar to a Task
6. Setting Up Resources in the Project
Understanding the Impact of Resources in the Project PlanAdding Work Resources to the ProjectAdding Resource Names ManuallyProposing Tentative ResourcesAdding Resources from Your E-Mail Address BookUsing Resource Information from Microsoft ExcelSpecifying Resource AvailabilityAdding Material Resources to the ProjectRemoving a Resource from the ProjectSetting Resource Working Time CalendarsViewing a Resource CalendarModifying a Resource CalendarCreating a New Base Calendar for ResourcesAdding Detailed Resource InformationWorking with Supplemental Resource FieldsSpecifying Workgroup InformationAdding a Note Regarding a ResourceHyperlinking to Resource Information
7. Assigning Resources to Tasks
Assigning Work Resources to TasksCreating Work Resource AssignmentsAdding and Assigning Resources at the Same TimeFinding the Right Resources for the JobUnderstanding Assignment CalculationsAssigning Material Resources to TasksReviewing Assignment InformationShowing Assignments by Task or ResourceShowing Assignment Information Under a Task ViewChanging Resource AssignmentsControlling Changes with Effort-Driven SchedulingControlling Schedule Changes with Task TypesUnderstanding the Fixed Units Task TypeUnderstanding the Fixed Work Task TypeUnderstanding the Fixed Duration Task TypeChanging the Task TypeContouring Resource Assignments
8. Planning Resource and Task Costs
Working with Costs and BudgetingPlanning Resource CostsSetting Costs for Work ResourcesSpecifying Variable Work Resource CostsSpecifying Fixed Resource CostsSetting Costs for Material ResourcesSetting Multiple Costs for a ResourceSetting Cost AccrualPlanning Fixed Task CostsReviewing Planned CostsReviewing Assignment CostsReviewing Resource CostsReviewing Task CostsReviewing the Total Planned Cost for the ProjectWorking with Multiple CurrenciesSetting Up a Different CurrencySetting Up Multiple Currencies in One ProjectConverting an EMU Currency to EuroConverting One Currency to Another
9. Checking and Adjusting the Project Plan
Working with the Critical Path and Critical TasksUnderstanding Slack Time and Critical TasksViewing the Critical PathBringing in the Project Finish DateViewing Finish Dates and the Critical PathChecking Your Schedule AssumptionsChecking and Adjusting Date ConstraintsChecking and Adjusting Task DependenciesChecking and Adjusting DurationsAdjusting Resource Settings to Bring in the Finish DateChecking and Adjusting Resource AvailabilityAdding Resources to Decrease DurationReducing Project CostsViewing Project CostsChecking Your Cost AssumptionsAdjusting the Schedule to Reduce CostsAdjusting Assignments to Reduce CostsBalancing Resource WorkloadsViewing Resource WorkloadsAdjusting Resource AvailabilityAdjusting AssignmentsAdding More Resources to TasksReplacing Overallocated ResourcesDelaying a Task or AssignmentSpecifying Overtime Work to Account for OverallocationsSplitting TasksLeveling AssignmentsSetting Leveling PrioritiesLeveling Resources with Standard DefaultsSetting Leveling OptionsChecking the Results of LevelingChanging Project ScopeReviewing the Impact of ChangesObtaining Buyoff on the Project Plan
3. Tracking Progress
10. Saving a Baseline and Updating Progress
Saving Original Plan Information Using a BaselineSaving a BaselineReviewing Baseline InformationSaving Additional BaselinesSaving Additional Scheduled Start and Finish DatesClearing a BaselineUpdating Task ProgressChoosing the Best Method for Entering ActualsUpdating Progress Using Task Scheduling ControlsUpdating the Project as ScheduledEntering Percent CompleteEntering Actual DurationEntering Actual Start and Actual FinishUpdating Progress Using Resource WorkEntering Percent Work CompleteEntering Actual Work Complete and Remaining WorkEntering Actual Work Complete by Time PeriodRescheduling the ProjectManually Updating Project Costs
11. Responding to Changes in Your Project
Monitoring and Adjusting the ScheduleMonitoring Schedule ProgressReviewing Overall Schedule ProgressReviewing Schedule VariancesReviewing the Critical PathReviewing Task ProgressWorking with Progress LinesCorrecting the ScheduleMonitoring and Adjusting CostsMonitoring Project CostsReviewing Overall Cost TotalsReviewing Cost VariancesReviewing Overbudget CostsReviewing Cost Performance Using Earned Value AnalysisReviewing Budget StatusRealigning the Project with the BudgetMonitoring and Adjusting Resource WorkloadMonitoring Resource WorkloadReviewing Overall Work TotalsReviewing Work VariancesReviewing Overbudget WorkReviewing Resource AllocationBalancing the Resource Workload
4. Reporting and Analysis
12. Reporting Project Information
Establishing Your Communications PlanSetting Up and Printing ViewsGetting Assistance from the Report Project GuideCopying a Picture of a ViewGenerating ReportsSummarizing with Overview ReportsUsing the Project Summary ReportUsing the Top-Level Tasks ReportUsing the Critical Tasks ReportUsing the Milestones ReportUsing the Working Days ReportFocusing on Tasks with Current Activity ReportsUsing the Unstarted Tasks ReportUsing the Tasks Starting Soon ReportUsing the Tasks In Progress ReportUsing the Completed Tasks ReportUsing the Should Have Started Tasks ReportUsing the Slipping Tasks ReportAnalyzing Budget Status with Cost ReportsUsing the Cash Flow ReportUsing the Budget ReportUsing the Overbudget Tasks ReportUsing the Overbudget Resources ReportUsing the Earned Value ReportEvaluating Resource Allocation with Assignment ReportsUsing the Who Does What ReportUsing the Who Does What When ReportUsing the To-Do ListUsing the Overallocated Resources ReportReviewing Resource Usage with Workload ReportsUsing the Task Usage ReportUsing the Resource Usage ReportRevising a Built-in ReportCopying an Existing ReportModifying an Existing ReportAdjusting the Page Setup of a ReportBuilding a Custom ReportGenerating Reports from Project XML DataPublishing Project Information to the Web
13. Analyzing Project Information
Analyzing Progress and Costs Using Earned ValueGenerating Earned Value DataSaving the BaselineEntering ActualsSpecifying the Status DateReviewing Earned Value DataWorking with Earned Value TablesUnderstanding the Earned Value FieldsGenerating the Earned Value ReportCalculating Project Information in Microsoft ExcelAnalyzing Numeric Project Data in ExcelExporting Selected Data to ExcelExporting Task, Resource, and Assignment Data to Excel at OnceAnalyzing Timephased Project Data in ExcelAnalyzing Project Data with Crosstab TablesCharting Project Data Using S-Curves
5. Managing Multiple Projects
14. Managing Master Projects and Resource Pools
Structuring Master Projects with SubprojectsSetting Up a Master ProjectInserting Projects into a Master ProjectBreaking Up a Large Project into SubprojectsWorking with Subproject InformationChanging Subproject Information to Read-OnlyViewing the Critical Path in a Master ProjectUnlinking a Subproject from Its Source FileRemoving a Subproject from the Master ProjectConsolidating Project InformationSharing Resources Using a Resource PoolSetting Up a Resource PoolLinking a Project to Your Resource PoolChecking Availability of Resource Pool ResourcesUpdating Resource Pool InformationDisconnecting a Resource Pool from a Project Plan
15. Exchanging Information Between Project Plans
Linking Information Between Project PlansLinking Tasks Between Different ProjectsReviewing Cross-Project LinksUpdating Cross-Project LinksRemoving Cross-Project LinksCopying and Moving Information Between ProjectsCopying and Moving Task and Resource InformationCopying Fields Between ProjectsCopying Project Elements Using the OrganizerCopying an Element from a Project to the Global TemplateCopying an Element Between Two Projects
6. Integrating Microsoft Project with Other Programs
16. Exchanging Information with Other Applications
Copying InformationCopying from Microsoft Project to Another ApplicationCopying from Another Application to Microsoft ProjectCopying a Picture of a ViewCapturing a View for Word, PowerPoint, or VisioCapturing a View for Other ApplicationsEmbedding InformationEmbedding from Microsoft Project to Another ApplicationEmbedding an Existing Microsoft Project FileCreating a New Microsoft Project File as an Embedded ObjectWorking with the Embedded Microsoft Project FileEmbedding from Another Application to Microsoft ProjectEmbedding an Object in the Gantt ChartEmbedding an Object in a NoteCreating a New Object to Embed in the ProjectWorking with the Embedded Object in the ProjectLinking InformationLinking from Microsoft Project to Another ApplicationLinking from Another Application to Microsoft ProjectHyperlinking to Documents in Other ApplicationsPublishing Project Information to the WebCreating Project XML DataImporting and Exporting InformationImporting Information into Microsoft ProjectExporting Information from Microsoft Project
17. Integrating Microsoft Project with Microsoft Excel
Copying Between Microsoft Project and ExcelCopying Information from ExcelCopying Sheet Information from ExcelCopying Graphics from ExcelCopying Information to ExcelCopying Sheet Information to ExcelCopying Graphics to ExcelEmbedding Between Microsoft Project and ExcelEmbedding an Excel Object in ProjectEmbedding Copied Excel Information in a Project FileEmbedding an Entire Excel File in a Project FileCreating a New Excel Object in ProjectWorking with the Embedded Excel ObjectEmbedding a Project File in ExcelEmbedding an Existing Project File in ExcelCreating a New Project File in ExcelWorking with the Embedded Project FileLinking Between Microsoft Project and ExcelLinking from Excel to ProjectLinking from Project to ExcelWorking with a Linked ObjectEditing Linked InformationUpdating Linked ObjectsViewing LinksImporting and Exporting with ExcelImporting from Excel to Microsoft ProjectImporting a Project Task List from ExcelImporting Detailed Project Information from ExcelImporting from Excel without a TemplateExporting from Project to ExcelExporting Selected Data to ExcelExporting Complete Project Data to ExcelExporting Timephased Information to Excel
18. Integrating Microsoft Project with Microsoft Outlook
Exchanging Task Information with OutlookAdding Outlook Tasks to Microsoft ProjectAdding Microsoft Project Tasks to Outlook TasksIntegrating Tasks Between Project Web Access and the Outlook CalendarSetting Up Outlook Calendar IntegrationImporting Project Assignments into the Outlook CalendarUpdating Assignments in the Outlook CalendarBuilding Your Resource List with OutlookExchanging Workgroup MessagesSending Project File InformationSending an Entire Project FileSending Selected Tasks or ResourcesRouting a Project FilePublishing the Project File to an Exchange Folder
19. Collaborating Using E-Mail
Setting Up E-Mail Workgroup MessagingUnderstanding System RequirementsDownloading and Installing the Workgroup Message HandlerPreparing Your Project Plan for E-Mail CollaborationSending Assignments and Updates to Team MembersSending Assignments to Team MembersReceiving Workgroup Messages from Team MembersSending Task Updates to Team MembersRequesting Progress InformationResending Task AssignmentsReceiving Assignments from the Project ManagerReceiving and Responding to AssignmentsProviding Assignment Status Updates
7. Managing Projects Across Your Enterprise
20. Understanding the Project Workgroup and Enterprise Model
Who's Who in Enterprise Project ManagementUnderstanding Project Server ComponentsUnderstanding Project Workgroup CollaborationUnderstanding Enterprise Project ManagementStandardizing and Customizing Enterprise ProjectsManaging Enterprise ResourcesAnalyzing Your Enterprise Project ActivitiesModeling Enterprise ImplementationsImplementing a Pyramid HierarchyImplementing a Tapered Block HierarchyImplementing a Straight Block Hierarchy
21. Administering Project Server and Project Web Access for Your Enterprise
Configuring Your Enterprise and WorkgroupManaging Users and System SecurityEstablishing User Accounts and PermissionsManaging SecurityCreating a New GroupSynchronizing with Active Directory Security GroupsCustomizing CategoriesCreating a New Security TemplateModifying a Security TemplateAdministering the Enterprise Resource PoolCreating the Enterprise Resource PoolAdding Multiple Enterprise ResourcesSynchronizing with Active Directory ResourcesAdding an Individual Enterprise ResourceImporting Existing Local Resources to the Project ServerUpdating Resource InformationDeactivating UsersCustomizing Enterprise Resource FieldsEstablishing Custom Resource FieldsEstablishing the Resource Breakdown StructureEstablishing Resource Outline CodesSpecifying Multiple Properties for a ResourceAssociating Resource Outline Codes with ResourcesEstablishing the Enterprise PortfolioPublishing Projects to the ServerConfiguring Portfolio Analyzer and Portfolio ModelerSetting the Enterprise Project VersionStandardizing Enterprise Project ElementsWorking with the Enterprise Global TemplateChanging the Enterprise GlobalCopying a Custom Element from a Project to the Enterprise GlobalCustomizing Enterprise Project FieldsEstablishing Custom FieldsEstablishing Enterprise Outline CodesSetting Up Team Member TimesheetsEstablishing the Update Method and RestrictionsEstablishing the Default Timesheet Fields
22. Managing Enterprise Projects and Resources
Connecting to Your Project ServerSetting Up Project Professional for Your ServerLogging On via Project ProfessionalLogging On via Project Web AccessWorking with Enterprise ProjectsCreating a New Enterprise ProjectSaving a New Enterprise Project to the ServerImporting a Local Project to the ServerMaintaining Your Enterprise ProjectsChecking Out an Enterprise ProjectReviewing the Enterprise Global TemplateWorking with Custom Enterprise FieldsChecking In an Enterprise ProjectWorking with Published Versions of Enterprise ProjectsWorking Offline with Enterprise ProjectsBuilding Your Enterprise Project TeamCreating Generic Resources as PlaceholdersWorking with Enterprise Resource Outline CodesAdding Enterprise Resource Outline CodesUsing Multiple-Value Enterprise Resource Outline CodesAssembling Your Project TeamAdding Enterprise Resources by NameFinding Enterprise Resources that Meet Specific CriteriaReplacing and Matching Existing ResourcesReplacing and Matching Generic ResourcesProposing Tentative ResourcesAssigning Tasks to Enterprise ResourcesCollaborating with Your Project TeamDesigning the Team Member TimesheetConfiguring Update OptionsSetting Up E-Mail NotificationsSetting Rules for Accepting UpdatesExchanging Information with Team MembersPublishing Information for Team MembersSubmitting Requests to Team MembersAccepting Updates from Team MembersManaging Documents, Risks, and IssuesControlling Project DocumentsMitigating Project RisksMonitoring Project IssuesTracking Non-Project Tasks and Time
23. Participating On a Team Using Project Web Access
Getting Started with Project Web AccessLogging OnFinding Your Way AroundWorking with AssignmentsAccepting New and Changed AssignmentsCreating New TasksAssigning Yourself to Existing TasksTracking Progress on Your AssignmentsSubmitting Progress InformationWriting Text-Based Status ReportsTracking Nonproject Tasks and TimeReviewing Task and Project InformationWorking with the Timesheet and Gantt ChartWorking with the Table FieldsShowing and Hiding Information in a ViewRearranging Your AssignmentsPrinting or Exporting a TableGlimpsing the Big Project PictureSetting Up E-Mail Reminders and CalendarsConfiguring E-Mail NotificationsWorking with Project Tasks in Your Outlook CalendarSetting Up Outlook Calendar IntegrationImporting Project Assignments into the Outlook CalendarUpdating Assignments in the Outlook CalendarManaging Risks, Issues, and DocumentsMitigating Project RisksMonitoring Project IssuesControlling Project DocumentsManaging Resources in Project Web AccessFinding the Right ResourcesAdding Resources to a ProjectReplacing and Matching Existing ResourcesProposing Tentative ResourcesReviewing Resource Allocation and AvailabilityDelegating Tasks to ResourcesUpdating the Enterprise Resource PoolCreating an Administrative ProjectSetting Up E-Mail NotificationsReviewing Resource Timesheets
24. Making Executive Decisions Using Project Web Access
Getting Started with Project Web AccessLogging OnGetting OrientedWorking with Views and FieldsUnderstanding FieldsRearranging View InformationPrinting or Exporting a TableAnalyzing Your Project PortfolioReviewing Summary and Detail Project InformationOpening Multiple Projects in Project ProfessionalAnalyzing Resource InformationReviewing Resource AssignmentsReviewing Resource AvailabilityExamining Projects Using Portfolio AnalyzerRunning Scenarios Using Portfolio ModelerSetting Up E-Mail Reminders and To-Do ListsConfiguring E-Mail NotificationsCreating To-Do ListsManaging Risks, Issues, and DocumentsMitigating Project RisksMonitoring Project IssuesControlling Project Documents
8. Customizing and Managing Project Files
25. Customizing Your View of Project Information
Customizing ViewsChanging the Content of a ViewCreating a New ViewChanging the Font for a ViewFormatting a Gantt Chart ViewFormatting the Appearance of Gantt BarsFormatting the Appearance of Gantt Bar TextFormatting the Layout of Gantt BarsFormatting the Appearance of GridlinesModifying a Network DiagramFormatting the Content and Appearance of BoxesFormatting the Layout of BoxesModifying the Resource GraphModifying the Appearance of Resource Graph BarsChanging the Information that Appears in the Resource GraphModifying the Calendar ViewModifying a Sheet ViewModifying a Usage ViewModifying the TimescaleCustomizing TablesModifying the Columns in a TableModifying Other Table OptionsCreating a New TableCustomizing FieldsCustomizing a FieldSpecifying the Values for a Custom FieldCreating a Calculated FieldCalculating Group and Summary ValuesWorking with Graphical IndicatorsCustomizing GroupsModifying a GroupCreating a New GroupCustomizing FiltersModifying a FilterCreating FiltersCreating Comparison FiltersCreating Filters with Multiple TestsCreating Interactive FiltersCustomizing AutoFilter CriteriaWorking with Outline CodesSetting Up Outline CodesSelecting the Outline CodeDefining a Code MaskControlling Outline Code ValuesDefining a Lookup TableAssigning Outline CodesReviewing Your Tasks or Resources by Outline CodeSharing Customized Elements Among ProjectsWorking with the OrganizerCopying Customized ElementsRemoving Customized ElementsRenaming Customized ElementsRestoring Customized Elements to their Default State
26. Customizing the Microsoft Project Interface
Creating and Customizing ToolbarsCustomizing ToolbarsAdding and Removing Buttons on a ToolbarChanging the Properties of a ToolbarCreating ToolbarsDeleting ToolbarsModifying Button ImagesCreating and Customizing MenusCreating and Customizing FormsCreating FormsAdding FieldsAdding TextAdding ButtonsAdding a Group BoxEditing FormsRenaming FormsDisplaying Custom Forms
27. Automating Your Work with Macros
Understanding MacrosWhat Is a Macro?Why Use Macros?Creating MacrosUnderstanding the Record Macro Dialog BoxKnowing When to Say "When"Recording a MacroLooking at Macro CodeRunning MacrosCreating Keyboard ShortcutsCreating Toolbar Buttons
28. Standardizing Projects Using Templates
Understanding the Template TypesWorking with the Project Global TemplateWorking with Project TemplatesStarting a New Project Using a TemplateCreating a New Project with a TemplateSaving Your New ProjectAdapting the Template to Your ProjectDownloading a Project TemplateCreating Your Own Project TemplateUpdating an Existing TemplateClosing a ProjectAnalyzing Project PerformanceRecording Lessons LearnedSaving Acquired Project Knowledge
29. Managing Project Files
Opening Project FilesOpening a Saved ProjectOpening a Project from Your Local Computer or a Network DriveOpening a Project from Project ServerOpening Projects Created in Previous Versions of Microsoft ProjectSearching for FilesSaving FilesSaving a New Project to Your Local Computer or Network DriveSaving a Project to Project ServerSpecifying the Default Save LocationSaving and Opening with Different File FormatsSafeguarding Your Project FilesSaving Project Files AutomaticallyBacking Up Your Project FilesProtecting Your Project Files with a PasswordResponding to a Microsoft Project Problem
9. Programming Custom Solutions
30. Understanding the Visual Basic Language
Understanding Objects, Properties, Methods, and EventsObjectsPropertiesMethodsEventsUnderstanding Data TypesUnderstanding VariablesUnderstanding ProceduresUnderstanding ScopeUnderstanding Decision StructuresUnderstanding Loop StructuresWriting Code That Is Easily UnderstoodNaming ConventionsDeclarationsNamed ArgumentsModularized CodeFormatted CodeWriting Efficient CodeTrapping Errors
31. Writing Microsoft Project Code with Visual Basic for Applications
Using the Visual Basic EditorWindowsTools MenuUnderstanding the Microsoft Project Object ModelWhat Is an Object Model?Useful Tools When Learning the Object ModelCreating MacrosWriting a Macro in the EditorDeciding Where to Create and Store ProceduresWorking with EventsCreating Application Event ProceduresCreating Project Event ProceduresDebugging MacrosUsing BreakpointsTracing ExecutionUsing WatchesUsing the Locals WindowUsing the Immediate WindowDebugging with Navigation ToolsCreating UserFormsCreating a Simple FormAdding Code to Your FormIntegrating Your Form into Microsoft ProjectExtending and Automating Microsoft ProjectWorking with External ReferencesUsing ActiveX ControlsUsing External LibrariesAutomating Microsoft ProjectAutomating with a Library ReferenceAutomating without a Library Reference
32. Working with Microsoft Project Data
Introducing Common Database ElementsStoring Data in a DatabaseUnderstanding Data in the DatabaseYes/No DataDates and TimesText DataSpecific ValuesMiscellaneous DataUnderstanding Project OLE DB Provider DataUnderstanding the Microsoft Project DatabaseUnderstanding the Project Server DatabasePartitioning Your Database on Separate ServersExperimenting with Project Server Using the Sample Database
10. Appendixes
A. Installing Microsoft Office Project 2003
Installing Project Standard and Project Professional 2003Project Standard and Project Professional System RequirementsSetting Up Project 2003 for the First TimeUpgrading from a Previous Version of ProjectActivating Project 2003Running Maintenance ModeAdding or Removing FeaturesRepairing Microsoft ProjectUninstalling Microsoft ProjectWorking with an Administrative Installation PointCreating an Administrative Installation PointAdding Your Company Name to the Default InstallationMicrosoft Office Project Server 2003 Setup IssuesMaking Decisions about Your Project Server SetupEnterprise Project Management System Requirements
B. Field Reference
Field TypesCurrency FieldsDate FieldsDuration FieldsEnumerated FieldsIndicator FieldsInteger FieldsOutline Code FieldsPercentage and Number FieldsText FieldsYes/No FieldsSpecial Field CategoriesCustom Fields and Custom Outline CodesEarned Value FieldsPERT Analysis Fields
C. Online Resources for Microsoft Project
Microsoft-Sponsored ResourcesIndependent Resources
D. Keyboard Shortcuts
E. Index to Troubleshooting Topics
Index
About the Author
Copyright

Content preview from Microsoft® Office Project 2003 Inside Out

Chapter 31. Writing Microsoft Project Code with Visual Basic for Applications

If you read Chapter 27, or if you've ever created a macro in Microsoft Office Project 2003, you already know that Visual Basic for Applications is one of the most powerful features of Project 2003. But there is much more to VBA (as it is more commonly called) than creating macros to automate repetitive, tedious, or complex tasks.

Note

Although Visual Basic for Applications is used to collectively describe the programming language and environment included with Microsoft Project, the language itself is Visual ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Microsoft® Office Project 2007 Inside Out

Publisher Resources

ISBN: 0735619581Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® Office Project 2003 Inside Out

by Teresa S. Stover

Chapter 31. Writing Microsoft Project Code with Visual Basic for Applications

Note

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.