Project Notes Export to Excel

[Andy Thomas]

I have a reporting process that is in Excel that reformats
information
from MS Project (2003 Standard) via a ADO recordset for selected Task
columns. Most of my users are basic MS Project users that aren't
able
to or prepared to save the project as a database, and so a simple
excel workbook with a form to select some parameters and a .mpp to
report against is what works for them.

I have done everything I need other than getting the Notes data into
Excel without losing data or fomatting - are there any suggestions
for
overcoming this problem?


Thanks

 

[Rod Gill]

No. Using ADO or automation you only get the text. If the project is saved
in a database, the notes are saved as rtf.

Note ADO and save to db are not supported by Project 2007.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

 

[Andy Thomas]

I was afraid of that!

I seem to be able to get the data (if not all the formatting) when I
manually cut and paste from Project to Excel - I'm presuming I can't
automate this process in VBA?

Thanks in anticipation.

 

[Rod Gill]

You can certainly do copy and paste using VBA, but it's slow.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com