Hi All,

I want to export the Task pane ( 6 columns) of the Gnatt view to a new Excel worksheet. I got the attached macro while browsing the related sites. The macro is expected to create a new Excel workbook and export the contents from Project view.
When I run the macro, I get the following error message:
User-defined type not define.

This message is for all the Excel worksheet data types starting from Excel.Range to other variables. When I check the data types in the drop down boxes, I do not find any reference to the Excel.<data type>. But this macro seems to be making rounds for quite some time and finds a lot of references at many web sites.
I installed MS Project 2007 recently and this is the first macro I am attempting to run on Project.

Is there any other add-in to be downloaded from the Microsoft web site?
Any help will be appreciated.

- Krishna