View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
luvgreen luvgreen is offline
external usenet poster
 
Posts: 33
Default Accessing MS Project from Excel

Greetings!

I need to access MS Project from excel. I need to filter all tasks in Project and then filter on critical tasks. I used the following codes. Sometimes it filters on critical, sometime it doesn't. How to make it work consistently? Your help is greatly appreciated.

'Show all data
FilterApply Name:="&All Tasks"

'Filter for critical Yes
FilterApply Name:="&Critical"