paste special picture from Excel 2007 to Publisher 2007 doesn't work

[Cathy Campbell]

I have a group of charts with text in surrounding cells that I want to copy and paste special picture enhanced metafile from Excel into Publisher. I have around 200 groups of these charts to paste into the Publisher file. What happens now is that the paste special command only reveals three options: new table, new text box, and HTML. When I copy paste special into Word the picture enhanced metafile is accessible and the image pastes fine. In Publisher pasting results in worksheet cells and the charts all in pieces and messy. I could copy the Word image into Publisher, but UGH!!200 TIMES. There must be a better way. I'm going to check for updates to Publisher and then ...start copying...unless someone has an alternative... please! :]

EggHeadCafe - Software Developer Portal of Choice
Getting PC information
http://www.eggheadcafe.com/tutorial...8c65-58b133610606/getting-pc-information.aspx

 

[Mary Sauer]

Have you tried, Insert, Object? Or using a capture program if you don't need to
edit the files. If you have Vista there is the Snipping Tool in Accessories.
TechSmith has a free trial offer for Snagit. A super program.
http://www.techsmith.com/screen-capture.asp?gclid=CI7Hy7DVqp0CFYZM5QodOnHIjQ

 

[JoAnn Paules]

Have you tried using Excel's Camera tool to create the graphic? Not sure if
you will get the results you want but it's worth trying.