Breather2008
06-18-2007, 08:42 AM
Hello,
I have a word document that is basically a skeleton document with a persons salary and benfits. When I run my macro in excel it updates all the fields with the persons name, salary and benefits without issue! My only problem is that in the word document I have made a pie chart that has all the columns formatted how I want.
I am now trying to make a macro that will take, lets say, the first four columns of row 1 in my excel document and paste it into the word chart spreadsheet so that the chart changes. Any help would be great! So far the only progress I have made is to activate the datasheet in the word document with the following line of code (but cant figure out how to edit the data!):
WordApp.ActiveDocument.Shapes(4).OLEFormat.Activate
Thank you for any help!!
I have a word document that is basically a skeleton document with a persons salary and benfits. When I run my macro in excel it updates all the fields with the persons name, salary and benefits without issue! My only problem is that in the word document I have made a pie chart that has all the columns formatted how I want.
I am now trying to make a macro that will take, lets say, the first four columns of row 1 in my excel document and paste it into the word chart spreadsheet so that the chart changes. Any help would be great! So far the only progress I have made is to activate the datasheet in the word document with the following line of code (but cant figure out how to edit the data!):
WordApp.ActiveDocument.Shapes(4).OLEFormat.Activate
Thank you for any help!!