Hi Marjie

if you want a "picture" of your gantt chart in an excel worksheet that
prints, in Project use the camera icon on the standard toolbar to generate a
gif and then put that in excel.

if you're after somthing else, please post your code as i'm interested to
see the "gantt chart which displays in excel" ... and then hopefully from
there figure out why it doesn't print

Cheers
JulieD

"Marjie" wrote in message
...
I would like to be able to import a gantt chart from MSProject to Excel
that
will be printable from the Excel worksheet.

I tried creating a connection to MSProject and then opening a recordset to
return tasks, dates fields and then binding the recordset, but the
resulting
gantt chart which displays in Excel does not print when I print the sheet.

Is there some way that I can transfer this data in gantt chart formatting
that I can then print from the Excel sheet?

I appreciate any help you can give me on this!