Question about Excel Worksheet

A

Aleksander

Hello,

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

Sincerely,
Aleksander
 
C

Cindy M.

Hi Aleksander,
How is it possible to transfer Excel Worksheet in the
Microsoft Word document into Edit mode using VBA?
Click to expand...
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
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Macro warning in word 1
Macros for Microsoft Excel Worksheet in Microsoft Word Document 1
Embedded Excel into Word with Tables 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0
Cell data entering slow! 0
Excel --> Word 4
Macro to copy table of contents to a new doc 0

Top