Use the Get workbook links action allows users to retrieve all external workbook links from an Excel.

Managing workbook links is essential for maintaining data integrity. With the introduction of this action, any possible inefficient screen recordings are now replaced with reliable, native solution for identifying linked workbooks in Excel files.

Considerations

An error is displayed if one of the following conditions are encountered when you deploy your automation to get workbook links in a Microsoft Excel file:
  • The session name that you have specified is invalid or does not exist.
  • If the workbook that you have specified does not have any source workbook links.

Settings

  • Use the Session name field to select one of the following tabs to specify the name of the Excel session provided using the Open action:
    • Session name: Enter the name you gave the session when you opened it. You can also click the Insert a value icon to select a variable or global value that you have used to store the Excel session name.
    • Variable: Select an existing variable that you have used to store the Excel session name.
  • Click the Assign the output to variable drop-down menu to select an existing variable to store the table data of workbook links successfully retrieved.
    Note: In the table data, the first column contains the file path and second column contains file name.

    If you have not created a variable, click the Create variable icon to create it.

    .