Can I do this with a hyperlink?

[troy_lee]

I want to present specific tasks in project. I have these tasks
flagged. What I want to do is to create a hyperlink in PP that brings
up Project. Simple enough, except that I need a hyperlink that will
execute a filter macro when the hyperlink is clicked in PP, thus
showing only those tasks that I would like for my audience to see.
This will save me from having to run the filter manually when I come
back to Project. That would also be simple, but this would be slicker.

Troy

 

[Rod Gill]

No. You should be able to Hyperlink to a project schedule and the ID of a
task in it, but any filter would have to be applied via a VBA macro that
runs automatically when the project opens.

Another way might be to regularly save the Tasks you want to show to a .html
file and hyperlink to that instead.

--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx

 

[Jim Aksel]

You may want to repost this to the Developer Group:
http://www.microsoft.com/office/com...rosoft.public.project.developer&lang=en&cr=US


I would use an action button to run a Macro within PPT.
You would write a Macro in PowerPoint that would wakeup the specific MS
Project File. Once the file is awake, your macro can apply a filter to the
project file.

You can do this in VBA, you will probably have to add a reference to the
Micrsoft Office 11.0 Object library in your PPT development.

The nice part about this is that you can write a Macro in Project that will
apply your filters/views for you. That code can be copied and pasted into
your PowerPoint macro... you just use Project as the "development environment"

So, the macro would have two parts: (1) Wakeup Project and open the correct
file, (2) Apply the desired filters/view.

There does not appear to be a command line switch to run a specific
macro/filter when project starts.

**********
Alternative -
Create the desired view in MS Project and save the file in that view with
the appropriate filters applied. Make sure you name the view.
Tools/Options/View. Change the startup view to your custom view in MS
Project. When you click the hyperlink to the mpp file from ppt, you will
see the desired view.



--
If this post was helpful, please consider rating it.

Jim
It''s software; it''s not allowed to win.

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