Export (save as) to Excel with Notes

P

Paul S

when "saving as" for an Excel workbook, I am trying to save the MS Project
Notes field but the contents are being truncated.
 
J

John

Paul S said:
when "saving as" for an Excel workbook, I am trying to save the MS Project
Notes field but the contents are being truncated.

Paul,
This issue has been addressed many times in this newsgroup. With a
direct copy or export the Notes field is truncated at 255 characters or
the first line feed, whichever occurs first. The easiest way to work
around this is either with a query to the Project database directly or
with a VBA macro. I have a couple of VBA macros that do just that,
export Project's Notes field to Excel. If you are interested, you may
contact me direct at the address below.

John
Project MVP
jensenj6atatcomcastdotdotnet
(remove obvious redundancies)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top