Скачать или смотреть How to Insert a Hyperlink at a Word Bookmark Using Excel VBA

Discover how to effectively add a hyperlink to a Word bookmark using Excel VBA with practical solutions and examples.
---
This video is based on the question https://stackoverflow.com/q/67588391/ asked by the user 'Shaves' ( https://stackoverflow.com/u/3827115/ ) and on the answer https://stackoverflow.com/a/67588951/ provided by the user 'Timothy Rylatt' ( https://stackoverflow.com/u/5211752/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Using Excel VBA to insert a hyperlink at a Word bookmark

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Insert a Hyperlink at a Word Bookmark Using Excel VBA

If you are delving into automation with Excel and Word, you may find yourself needing to add hyperlinks within Word documents through Excel VBA. This is a common task, especially for those who manage templates and want to streamline their document creation processes. However, it can get tricky when dealing with bookmarks and properly inserting hyperlinks. In this guide, we’ll explore how to accomplish this and solve a common issue you might encounter.

The Problem: Adding a Hyperlink at a Bookmark

You may run into issues when trying to add a hyperlink to a specific bookmark in a Word template using VBA. As illustrated in a real-world scenario, a user attempted to insert a hyperlink at a bookmark called "WebAdd" using the following code:

[[See Video to Reveal this Text or Code Snippet]]

This code led to a Type Mismatch error. Additionally, an alternative attempt just placed the web address as text at the bookmark but failed to create a clickable hyperlink. Here's the code that caused this:

[[See Video to Reveal this Text or Code Snippet]]

Neither of these options produced the desired outcome. Let's break down the solution.

The Solution: Correctly Adding a Hyperlink

The key to successfully inserting a hyperlink at a bookmark in a Word document using VBA lies in providing the correct anchor. The anchor for your hyperlink should be a Range object rather than a string. Below is the solution that resolves the issue:

Step-by-Step Code

Here’s the corrected code snippet to add a hyperlink:

[[See Video to Reveal this Text or Code Snippet]]

Explanation of the Code

With WrdApp.ActiveDocument: This specifies that you are working with the active Word document opened through Excel.

Bookmarks(BookmarkName).Range: This is the crucial part. Instead of using a string, the code uses the range of the specified bookmark as the anchor for the hyperlink.

Address:=MyWebAdd: This is where you specify the actual web address that the hyperlink will point to.

TextToDisplay:=MyWebAdd: This defines what text will be displayed in the document for the hyperlink.

Final Thoughts

By using this adjusted approach, you not only create a hyperlink that is correctly linked to your specified bookmark but also avoid the common pitfalls of type mismatches and functionality issues. Remember always to refer to the Word Object Model in VBA to ensure you’re using the correct properties and methods.

Automating Word with Excel VBA might seem daunting at first, but with these insights into adding hyperlinks at bookmarks, you can enhance your macros significantly. Happy coding!