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!