My best guess is that you pasted the macro into the subroutine that is created when a module is created.
I created a Calc Document and then I placed the macro as a module in the standard library of the Calc document. I tested the code and it seems to work just fine. I will mail you the Calc document directly. Because the macro is in the Standard Library of the document, the macros are always available for that document as functions. On the other hand, I think that you cannot import the Standard library into another library container (such as a document), so you would need to manually copy the macros into a new document. Enough testing for me for now, I have some other things I need to do, but, watch for the document by itself. I do not believe that I can post the document (attachement) to the list. cheers! 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 >
