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