Macros

[Django32]

I tried to creat a Macro whhich allows MS Project to:

1. Copy the MS Project Data
2. Open an Excel File
3. Paste data to the Excel file.

Can this be done or am I asking too much from MS Project
2000. Appreciate any info provided.

Django

 

[Gérard Ducouret]

Django,

It would be easier to export the Project data to Excel via a map :
File / Save as.. / FileType : Microsoft Excel Workbook (*.xls)
and select the fields you want to export to Excel.

Gérard Ducouret

 

[JackD]

It is not very difficult at all.
I have at least one example of this you can look at on my website.
http://masamiki.com/project/macros.htm
The export heirarchy to excel macro shows the basics.

-Jack