tonymagnetic
New Member
- Joined
- Oct 20, 2004
- Messages
- 17
Hi & Thanks for having a look.
I'm hoping that this is an easy one, cause its been driving me nuts all day!
I have a series of forms and fields that interact to feed 6 output variables into a table in word. The cells collectively have the bookmark "GTable".
Later in the document I have an embedded MS graph that needs to be updated based on changes in the above table. The graph object has the bookmark "GGraph".
I am trying to build a vba macro that will copy the data in the table, open the graph object's datasheet, and paste the table date in cell ("A1").
Been fooling around with the macro recorder and some assorted pieces of code I have come across, but it seems that I cannot successfully paste the info into the datasheet on a regular basis. Any ideas?
Thanks again,
TonyM
I'm hoping that this is an easy one, cause its been driving me nuts all day!
I have a series of forms and fields that interact to feed 6 output variables into a table in word. The cells collectively have the bookmark "GTable".
Later in the document I have an embedded MS graph that needs to be updated based on changes in the above table. The graph object has the bookmark "GGraph".
I am trying to build a vba macro that will copy the data in the table, open the graph object's datasheet, and paste the table date in cell ("A1").
Been fooling around with the macro recorder and some assorted pieces of code I have come across, but it seems that I cannot successfully paste the info into the datasheet on a regular basis. Any ideas?
Thanks again,
TonyM