Hello Brian,
I had time today to copy the Basic macro code in the link provided today
into a test spreadsheet. I pasted the code between "Sub Main" and "End
Sub". I then saved the macro. When I attempted to compile the macro I
got the following error.
BASIC syntax error.
Function not allowed within a procedure.
What am I doing wrong?
David
On 8/17/2020 9:12 AM, Brian Barker wrote:
At 08:18 17/08/2020 -0400, David Stuhr wrote:
I have an OpenOffice spreadsheet that has over a thousand hyperlinks
to an external www website. The information in each hyperlinked cell
is the URL and descriptive text. From a search of the web it appears
that Excel has a "get URL" function but a search of OpenOffice help
did not return a similar function.
Is there a method/way of getting the URL in a cell that contains a
hyperlink and putting it in another? I want to do this to identify
duplicate URL references.
See
https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice
- which includes a function CELL_URL() which appears to provide what
you need.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org