VBA code go to specific location in embedded document

C

Charlotte

From Excel I'm opening an embedded OLE object (Word document). Once
the document is open, I need to be able to go to a location in the
document (preferably by keyword search). Is this possible?

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$A$4" Then
Set Obj = Sheets("report").OLEObjects("Object 1")
Obj.Activate
End If
End Sub
 

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

Return to Excel from Word Object 1
Hyperlinks in two different cells 1
from excel to word 0
Macro attached to Autoshape Hyperlink not invoking 0
Hyperlink events 2
Excel 2003 - VBA Code Problem 4
How do I add a hyperlink to specific location in another document 0
Running code when hyperlink clicked 6

Top