Nope, sorry, I did the work, but I could not send an email to your email address. Did not bother trying to figure out why, might be because my email is not letting me send the macro attachment, in which case I need to fix my outgoing email server or if yours rejected it. I will look at this later.
On Tuesday, August 18, 2020 17:40 EDT, David Stuhr <david.st...@verizon.net.INVALID> 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 >
