How do I export from Project to Excel?

[Amy]

I followed the directions, when I went to project I copied and paste the
macro to the global.mpt file. Then what do I do? I did the wizard and it
still didnt retain the indentations?

 

[JulieS]

Hi Amy,

What directions? Where did you get the macro from? Give us a bit more
information and we'll try to help.

Julie
Project MVP

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

 

[Amy]

http://masamiki.com/project/macros.htm

Hi Amy,

What directions? Where did you get the macro from? Give us a bit more
information and we'll try to help.

Julie
Project MVP

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

 

[JulieS]

Hi Amy,

If you are referring to Jack Dahlgren's Export hierarchy to Excel macro,
you need to run the macro (Tools > Macro > Macros to perform the export.

I hope this helps. Let us know how you get along.

Julie
Project MVP

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

 

[John]

Hi Amy,

If you are referring to Jack Dahlgren's Export hierarchy to Excel macro,
you need to run the macro (Tools > Macro > Macros to perform the export.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Amy,
Just a couple of words to expand on what Julie said. First, Jack's
"Export hierarchy to Excel" macro is a stand alone VBA macro. It has
nothing to do with the "Analyze Timescaled Data in Excel" wizard nor the
import/export map wizard.

If indeed you copied it successfully to your Global, Jack's macro will
show up in the list of available macros when you go to
Tools/Macro/Macros as Julie suggested. Just select it and hit "Run".

John
Project MVP

 

[Amy]

Thanks, it worked, however, I need a filtered list. I guess I will do it
manually. Thanks again for all your help.

 

[JackD]

It shouldn't be much trouble to filter the information.
Tell me what you want to filter on and I'll tell you what you need to add to
your code.
It will be something as simple as:

if task.name = "export" then
'put the rest of the code inbetween these lines
end if

You can filter in a macro quite easily and with many more possibilities.

-Jack

 

[John]

Thanks, it worked, however, I need a filtered list. I guess I will do it
manually. Thanks again for all your help.

Amy,
You're welcome. It looks like our main man, Jack has picked it up from
here.

John