-
Solved: Exporting Project 2007 Gnatt view to Excel
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules