MS Word Hyperlink Extraction

[KhushbooKumari]

Hello Team,

Request you to advise how to extract hyperlink from MS Word file.

Thanks & Regards
Khushboo Kumari

------------------------------
Khushboo Kumari
Junior Configurator
HSBC
Asia/Kolkata
------------------------------

[devneetmohanty07]

Hi Khushboo,

For your given use case, you can extend the MS Word VBO by creating your own custom action as shown in the solution below:

Solution Walkthrough:

In order to achieve this, we can extend the "MS Word VBO" by creating a separate action within it and you can call it as "Get Hyperlinks". This action will be having the following input parameters:

1. handle (Number) : The data item having the handle value in the instance dictionary that needs to be queried. (This you can get from Create Instance action)
   
   
2. document Name (Text) : The document name of the current workbook which the Blur Prism bot is operating on. (This you can get from Open Workbook action)

This action will also have an output parameter called 'Hyperlinks' which is of Collection type which will consist of all the extracted hyperlinks from the supplied word document.

Refer to the below workflow for more information:


Input Parameters:


Output Parameters:




Now, add a custom code stage with the following Input & output parameters and the code as shown below:




Code:

Dim wDoc As Object = GetDocument(handle,document_name)
Dim i As Integer
Dim dt As New System.Data.DataTable
Dim dr As System.Data.DataRow

dt.Columns.Add("Hyperlink", GetType(String))

For i = 1 To wDoc.Hyperlinks.Count Step 1

            dr = dt.NewRow
            dr("Hyperlink") = wDoc.Hyperlinks(i).Address
            dt.Rows.Add(dr)

Next

Hyperlinks = dt


You can publish this action and run the same from Process Studio to check your results.

Some of the test results are shown below:


Scenario: I have added two hyperlinks in my word document for Google and Linkedin:





Result of the action is:



Let us know if this helps you and also if you have any queries feel free to reach us out!

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------