Editing an embedded excel file in MS Word using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mat - 05 Sep 2005 23:03 GMT

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

Reply to this Message

Word Heretic - 06 Sep 2005 02:27 GMT

G'day mat <mat@discussions.microsoft.com>,

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:

>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
[quoted text clipped - 4 lines]
>
>Thanks

Reply to this Message