okay, i'll start "googling"

Cheers
JulieD

"Marjie" wrote in message
...
I forgot to mention that I had the code running on the activate event of
the
worksheet. As for the connection string, I was working with code from a
coworker so I'm afraid I don't know much about connection strings either.

"JulieD" wrote:

Hi Marjie

glad it worked for you. I was very interested in your code - but
couldn't
get it to run (don't know much about connection strings) - do you have
any
references where i could learn more about this topic

Regards
JulieD

"Marjie" wrote in message
...
Julie,

Thanks this works nicely with my project
Marjie

"JulieD" wrote:

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!