iRobo.Activity.Get Hyperlink

Extracts a hyperlink from a specific cell in an Excel Sheet.


     Note: 

         Before using Office Activities, check Office Automation prerequisites from Office Page.

         Get Hyperlink is one of the Excel activities that requires Excel Scope Activity.

               

                                                                                               

Properties

Excel

  • SheetName -  Excel Sheet name of current Workbook. Default value: "Sheet1".


Input

  • Cell - Enter cell position as: "A1". (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds.


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Address -  String Variable to get selected hyperlink address. (Mandatory)


Steps of Using Get Hyperlink

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Get Hyperlink Activity into Excel Scope Activity Body.
  3. Enter cell position number in Cell field in Property Panel.
  4. Enter Output String Variable for the hyperlink address in Address field in Property Panel.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process.


Created with the Personal Edition of HelpNDoc: Free Kindle producer