vba linking Excel and Word

M

Mr BT

I need to have my Excel custombutton open a specific DOC file.
I have several bookmarks in the DOC file I would like to reference as part
of a help file.
I have figured out how to open the DOC file using hyperlink vb as below:

'
ActiveWorkbook.FollowHyperlink Address:= _
"C:\HelpFile\Help Me With Find Duplicates.doc", NewWindow:=False, _
AddHistory:=True
End Sub

If I'm not able to find the bookmarks with this script (please fill in the
blanks above) then I will need to have over 50 txt files using the above
(replace .doc with .txt)

If anyone can help I would appreciate the assistance.

Mr BT
 

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

Integrating information from Word to Excel (not mail merge) 1
Merging from an Excel file with graphics 1
Shortcuts in OneDrive 0
Word macro that can call cells out of Excel for a find and replace 0
You'll need a new app to open this about link 1
VBA to Find Key Words in Word doc then Extract Content to Excel.xlsm file 3
Pasting a cell into bookmarked table from excel vba 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top