Paste Special Excel Chart macro

D

Dave Stauffer

Hi, all. I have a word document that mail merges a datafile and a
linked Excel chart to print some employee benefit statements. Up until
now, my macro has sent the appropriate numbers to Excel to update the
chart, printed the merged document, then discarded it, moving to the
next row for each employee. However, my company would now like to
outsource the printing (color) to a third party. I find that if I save
each merged document separately, then open them one by one, the charts
all contain the same set of numbers.

What I can do manually is select the chart, cut it, and paste special
as a picture in the same location before saving the file. I'm not sure
how to do that in a macro. The record-macro function won't let me
select the chart with the mouse, among other things.

Can anyone give me some sample code to accomplish this? Thanks so much
for any help.

--Dave
 
D

Doug Robbins - Word MVP

Hi Dave

Try unlinking the fields in the documents

[document object].Fields.Unlink

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Top