Generate Hyperlink on live sheet

Help Activities
, ,
1

Hello,

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?

Thanks

2

Hi @GoldCutlery

welcome back to community

Try to invoke the vba code to insert hyperlink in cell using invoke vba activity, it makes the excel to open while adding the link

Reference: VBA Hyperlinks - Automate Excel

Thanks & Regards,
Nived N

3

@GoldCutlery Please go through below post

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.