VBA - Filters

[Satya Srinivas Kumar]

I have gone thru the following web site on how to write Macros in VBA for
Ms-Project.
http://masamiki.com/project/macros.htm

The site really explains in a very developer friendly manner.
I am trying to do the following,

[1] apply a filter, that is already created
[2] The tasks that are resulted from the above filter condition will be
exported to Excel.

I am able to export the tasks from Ms-Project to Excel using VBA macro
provided.

Can some one help me how to acheive the above.

Thanks in Advance

 

[Brian K - Project MVP]

I have gone thru the following web site on how to write Macros in VBA for
Ms-Project.
http://masamiki.com/project/macros.htm

The site really explains in a very developer friendly manner.
I am trying to do the following,

[1] apply a filter, that is already created
[2] The tasks that are resulted from the above filter condition will be
exported to Excel.

I am able to export the tasks from Ms-Project to Excel using VBA macro
provided.

Can some one help me how to acheive the above.

Thanks in Advance

Try using the macro recorder. It works great. Just create a new map during
the save you are recording and you can specify a filter right in the map
dialog.

 

[John]

"Satya Srinivas Kumar" <Satya Srinivas Kumar

I have gone thru the following web site on how to write Macros in VBA for
Ms-Project.
http://masamiki.com/project/macros.htm

The site really explains in a very developer friendly manner.
I am trying to do the following,

[1] apply a filter, that is already created
[2] The tasks that are resulted from the above filter condition will be
exported to Excel.

I am able to export the tasks from Ms-Project to Excel using VBA macro
provided.

Can some one help me how to acheive the above.

Thanks in Advance

Satya,
I'm a little confused. Your post says you ARE able to export the
filtered tasks using Jack's VBA code (I assume you are referring to his
"Export hierarchy to Excel" macro), so what is the question or issue?

John
Project MVP

 

[Mike Glen]

Hi Satya ,

Next time, try posting on the developer newsgroup. Please see FAQ Item: 24.
Project Newsgroups. FAQs, companion products and other useful Project
information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP