This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C8EDCA.C97D7C00
Content-Type: text/plain;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable

Hello,

How is it possible to transfer Excel Worksheet in the Microsoft Word =
document into Edit mode using VBA?

Sincerely,
Aleksander
------=_NextPart_000_000C_01C8EDCA.C97D7C00
Content-Type: text/html;
charset="windows-1251"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1251">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD><FONT face=3DArial><FONT size=3D2>
<BODY>
<DIV>Hello,</DIV>
<DIV>&nbsp;</DIV>
<DIV>How is it possible to transfer Excel Worksheet in the Microsoft =
Word=20
document into Edit mode using VBA?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Sincerely,</DIV>
<DIV>Aleksander</DIV></BODY></HTML></FONT></FONT>

------=_NextPart_000_000C_01C8EDCA.C97D7C00--

Re: Question about Excel Worksheet by Cindy

Cindy
Tue Jul 29 05:44:59 PDT 2008

Hi Aleksander,

> How is it possible to transfer Excel Worksheet in the
> Microsoft Word document into Edit mode using VBA?
>
Assuming that the Excel worksheet (actually, it's a
workbook displaying a sheet) object is positioned in-line
with the text and it's the first in-line graphic in the
document:

ActiveDocument.InlineShapes(1).OLEFormat.Activate

If it has text wrap formatting applied:

ActiveDocument.Shapes(1).OLEFormat.Activate

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 17 2005)
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
:-)