macro to open Project/Project Info/Statistics

J

Jesse

I'm not a developer.....

I frequently like to view project statistics in Project Pro 2003. I created
a button and attached a the following recorded macro:

Sub Statistics()
' Macro Statistics
ProjectStatistics Project:="Project1"
End Sub

I think this should work fine if I'm in "project1". How do I make this
macro to open the project that's currently open?
 
J

John

Jesse said:
I'm not a developer.....

I frequently like to view project statistics in Project Pro 2003. I created
a button and attached a the following recorded macro:

Sub Statistics()
' Macro Statistics
ProjectStatistics Project:="Project1"
End Sub

I think this should work fine if I'm in "project1". How do I make this
macro to open the project that's currently open?
Click to expand...

Jesse,
Boy, it seems like overkill to go the the trouble of creating a button
and a macro to display something that is readily accessible under
Project/Project Information. However, it should work fine by just
leaving off the Project argument. In other words, use the following:

Sub Statistics()
' Macro Statistics
ProjectStatistics
End Sub

Hope this helps.
John
Project MVP
 
J

Jesse

Thanks John!
--
Jesse


John said:
Jesse,
Boy, it seems like overkill to go the the trouble of creating a button
and a macro to display something that is readily accessible under
Project/Project Information. However, it should work fine by just
leaving off the Project argument. In other words, use the following:

Sub Statistics()
' Macro Statistics
ProjectStatistics
End Sub

Hope this helps.
John
Project MVP
Click to expand...
 
J

JulieS

Hi Jesse,

Congratulations on experimenting with VBA. For your reference, there is
a toolbar button on the Tracking toolbar which will also display the
Project Statistics dialog box..

If you don't wish to display the tracking toolbar, you can also add the
button to one of the other toolbars through Tools > Customize >
Toolbars.

--
I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Open,Save Projects in C# 3
Unable to Activate() a Project within the Application.Projects() 7
Improving Macro That Keeps First Letter 0
Opening a Project in SQL Server Using VBA 8
Finding statistical information in database 3
Getting Percent Complete info in MS Project 10
Outlook macro 0

Top