Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
Looking for VBA code to copy Excel chart to Word
Name:
Barry
Email (spam proof):
Email the originator of this post
Date:
Friday, September 23, 2005
Hits:
62
Discussion (Terms and Conditions):
I'm going nuts. I have searched and searched the Internet for a way to copy a chart in Excel and then automatically paste it in Word. Then move back to Excel and copy a table from a range of cells and move that to Word also. I have managed to move in Excel and copy the correct chart and then open Word but after that I cannot paste the chart. I end up in Word and if I manually clicked paste then it works (that is how I know I have copied the right chart). There must be code that once I have the correct chart and am in Word that the chart gets pasted. Does anyone know how to do this? I figure once I can paste in Word then I can figure out how to move back to Excel and copy the table. Please help.

Sponsored by the best FTP application on the internet: