Hello,
I figured out a very low tech solution ... save as an HTML file, a
little editing and a file import. Done. Sometimes simpler is better and
I know I will fully understand what I am dong. :-)
I would be more than happy to write up a cheat sheet of the steps in the
procedure that I am yet to devise. (But I know I can do it.)
I want to thank the members of the group for the unpaid work that you
do. I for one appreciate what each of you do. I look forward each day to
the question/problems users present and the thoughtful attention you
give to the issues raised. Keep up the good work.
I think in this day and age that a function that would get the URL from
a Hyperlink in a spreadsheet cell would be entirely appropriate. Does
the team/individual that maintains OpenOffice have a "suggestion" box?
David
On 8/18/2020 5:40 PM, David Stuhr wrote:
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
