Automatic Transfer of Excel charts into word document

[fred engel]

I am producing a word report using labview acquiring data from spectrum analyser.The plot is too complicated to produce with Word easy chart, so all data is sent to excel and the chart plotted there. The chart then needs to be manually copied from excel and pasted into the right location in the word report.
I want to automate the transfer of these charts. The process is run many times over, and the word doc needs to be produced automatically every run, with the appropriate charts each time. Labview dumps all of the data into an excel template which draws the charts etc. Labview also produces the word doc with everything in place except the chart drawn by excel. The excel and the word doc then sit open on the screen waiting for the user to copy the charts from excel to the appropriate places in the doc, and save and print the doc.

Can anyone help me find a way to automate this last step - the placement of selected charts (all in selarate worksheets in excel) into selected locations (bookmarks?) in the word doc.

Thanks

Fred Engel

[Kenny_K]

You can do this by using the activeX controls of Word and Excel.  It is easier to do it if the name of the worksheets are the same but you can do it if the name changes by pointing to the number of the wroksheet (1,2,3 etc)

you can then point to the chart on Worksheet 3, copy it, and then paste it into the word doc.

Ill work on an example for you and get back to you.

[Joe_H]

For more information and some sample VI's and tool kits, you can go to the excel board

[Kenny_K]

Here are some other threads:  one, two, three

I am sure there are more out there, just a quick search.