-
leaving an embedded object (excel sheet) and returning back to word
Hi all,
i have been looking into this myself but cant find a way to make it work.
I have a word document with embedded excel tables (formulas, external references) and to make sure they get updated when the document is opened i wrote a bit of code to select them
<code>
For Each s In ActiveDocument.InlineShapes
If s.Type = wdInlineShapeEmbeddedOLEObject Then
If InStr(1, s.OLEFormat.ProgID, "Excel") Then
s.OLEFormat.Activate
End If
End If
Next
<\code>
This is executed upon opening the document. Problem is the focus stays on the last opened table and i cant find a way to release it.
Any help?
PS : this is word 2003
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules