Editing an embedded excel file in MS Word using VBA

[mat]

I have a word document with several embedded excel worksheets. I am trying
to edit the formula on few cells in the embedded worksheet. Since I have to
change the formula on several files I want to write VBA code to make the
changes.

Any help in writing the code is appreciated.

Thanks

 

[Word Heretic]

G'day mat <[email protected]>,

The excel object can be .Activated or you can do a DoVerb open. Then
you need to address the new task, "Microsoft Excel" and send it excel
commands to do the work.


Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


mat reckoned: