Prev: Calculate duration
Next: Fiscal Month Calendar
From: "Satya Srinivas Kumar" <Satya Srinivas Kumar on 23 Aug 2005 18:45
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


From: Brian K - Project MVP on 23 Aug 2005 20:00
Satya Srinivas Kumar wrote:

>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.

--
Brian K - Project MVP
http://www.projectified.com
--
Senior Trainer - Electronic Arts
--
QuantumPM Associate
http://www.quantumpm.com
From: John on 23 Aug 2005 20:26
In article <6A66683E-14ED-4509-8A57-BA7FFD31DD71(a)microsoft.com>,
"Satya Srinivas Kumar" <Satya Srinivas Kumar
@discussions.microsoft.com> wrote:

> 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
From: Mike Glen on 24 Aug 2005 06:32

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


Satya Srinivas Kumar wrote:
> 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



 | 
Pages: 1
Prev: Calculate duration
Next: Fiscal Month Calendar