Hello!
I have an calc sheet with cells that contain “=hyperlink(/path_to_file)” formulas.
I can Ctrl-click them no problem. But I wanted to make buttons to click them.
Unfortunately all I found on the internet makes use of ActiveWorkbook or Application. And so far - I can’t figure out how to make them to work - I get an error “Object not set”.
but, what you want? open the same file with a command button?
This is VBA-speak. I wouldn’t expect such code to work even under
Option Compatible or Option VBAsupport 1
and I also won’t test this.
Providing scripts and their invokation may be very specific to the actually underlying application which here is LibreOffice.
How to do it with the help of the real API isn’t actually complicated.
The most ticklish question may be to get the script-URI itself from the cell with the HYPERLINK() formula if it not is the cell.String at the same time. If you actually want to go this funny way, you may need to look into the cell.Tokens property accepting lots of possible complications.
I would definitely dissuade from this approach, and I didn’t demonstrate a workaround for it. Either HYPERLINK() or Button.
You may base additional considerations on the attached example. It contains (raw) user code. Check it for the absence of malign parts first, and permit execution of tzhe documentz macros then.
disask97827followSelectableLinkOnButtonClicked.ods (23.0 KB)