Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2016, 08:46 AM
jerrysumpster jerrysumpster is offline Planning Quality Macro/VBA sought Windows 10 Planning Quality Macro/VBA sought Office 2010 32bit
Novice
Planning Quality Macro/VBA sought
 
Join Date: Jun 2016
Posts: 3
jerrysumpster is on a distinguished road
Post Planning Quality Macro/VBA sought

Just asking to see if someone might already have developed something to check and report where:
Duration contains ?
Milestone has duration > 0
Incomplete Tasks with dates in the past
Tasks without predecessors/successors
Tasks with lags/leads on dependencies
Relationships other then FS
Hard constraints checks
High Float check


Negative float check
High duration check

I have custom filters but very manually intensive, looking to see if anyone has macros, VBA or reports that cover each or all of the above?
Reply With Quote
  #2  
Old 06-13-2016, 09:11 AM
JulieS JulieS is offline Planning Quality Macro/VBA sought Windows 7 64bit Planning Quality Macro/VBA sought Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

If you have the filters created, consider recording a macro to apply the filter. Or consider putting the filters on a custom ribbon for easy access. You may also want to post to the Microsoft forum for project customization:

https://social.technet.microsoft.com...ct2010custprog
Reply With Quote
  #3  
Old 06-13-2016, 09:37 AM
jerrysumpster jerrysumpster is offline Planning Quality Macro/VBA sought Windows 10 Planning Quality Macro/VBA sought Office 2010 32bit
Novice
Planning Quality Macro/VBA sought
 
Join Date: Jun 2016
Posts: 3
jerrysumpster is on a distinguished road
Default

Thanks Julie, will investigate customization forum.
Sadly your suggestion wont work, as I am assessing other Project Managers MSP files for quality, filters don't exist in those files.
Reply With Quote
  #4  
Old 06-13-2016, 12:47 PM
JulieS JulieS is offline Planning Quality Macro/VBA sought Windows 7 64bit Planning Quality Macro/VBA sought Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You can place the filters in your global and they should be accessible. Go to File > Info, Organize and copy your custom filters to the Global template.
Reply With Quote
Reply

Tags
macor, planning quality, vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Event planning cajos Project 3 03-26-2016 05:19 PM
Planning Quality Macro/VBA sought Word 2013 - Viewing images in smaller quality but printing in normal quality JungleMan Word 1 10-03-2015 02:00 PM
Planning Quality Macro/VBA sought Macro help sought for Word table xan Word VBA 1 04-20-2012 07:50 PM
Planning Quality Macro/VBA sought Poor Image Quality DataSys PowerPoint 1 09-15-2009 11:40 AM
Access "Find Word" parameters sought nrg Office 0 06-29-2005 10:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft