Andrew you need to remove the .INVALID from the end of his email address. Sent from my iPhone
> On Aug 18, 2020, at 5:25 PM, Andrew Pitonyak <and...@pitonyak.org> wrote: > > > 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 >> > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
