Add numbers to a Excel sheet From MS Word doc using VBA

[herman]

I have macros in my MS Word to assist in marking essay's by inserting
standard comments to the documents (with buttons in the menue bar).
I would like to have a graph automatically update as I run these
macros.
Therefore I need to either link to an excel sheet and insert numbers
into the Excel sheet by using "MS Word macro's", or i need to be able
to change an embedded sheet with macros in word.

Hope all that makes sense

Can someone please help
Herman

 

[Cindy M -WordMVP-]

I have macros in my MS Word to assist in marking essay's by inserting

standard comments to the documents (with buttons in the menue bar).
I would like to have a graph automatically update as I run these
macros.
Therefore I need to either link to an excel sheet and insert numbers
into the Excel sheet by using "MS Word macro's", or i need to be able
to change an embedded sheet with macros in word.

Hope all that makes sense

Oh, it makes sense. And it can be done. You might start by looking at
the "run Excel from Word" article at word.mvps.org

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail