Problem running macro in Project

[Melissa]

I really need to export a Project plan's tasks to Excel so I can distribute
the information to team members that don't have Project. I would really like
to link the information in Project to the Excel spreadsheet so I don't have
to update both. I've tried doing Copy/Paste link as a Project object which
is just a picture that doesn't show everything and is uneditible. I've also
tried Copy/Paste link as Excel format which doesn't have any of the
formatting seen in Project and is very hard to read because all of the
hierarchies are gone.

I've followed the directions for Jack's macro 'Export hierarchy to Excel'
and copied the code into a new VBA module within Project. When I try to run
the macro I get the message "Compile Error: User-defined type not defined"
and the 2nd line of code 'Dim xlrow As Excel.Range' is highlighted.

Any help at all would be greatly appreciated! Keep in mind that I'm fairly
new to MSProject and do not know VBA at all.

 

[JulieS]

Hi Melissa,

My guess would be that you are missing to reference to Excel. See the
information at the following page, last paragraph about checking for the
Excel object library.

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

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

 

[Melissa]

Hi Julie,

Thanks for input, I did that process once but when I looked again, it was
unchecked so I redid it. Thanks for your help!

 

[JulieS]

You're welcome Melissa and thanks for the feedback. Glad to know all is
working well now.

Julie
Project MVP

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