I am trying to have a bot generate a hyperlink with a given cell location, hyperlink address and text to display.
I have tried BalaReva’s Insert Hyperlink activity. It works great but it requires the workbook be closed before it can create the hyperlink. I need the workbook to stay open during the run.
I tried having the bot go through the manual Insert Hyperlink process within Excel. I found that the bot was inconsistent with how often it would work due to Excel sometimes not accepting the text to display as being the correct format.
Has anyone had any luck with a inserting a hyperlink into a “live” excel sheet?