At 17:40 18/08/2020 -0400, 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
At 19:38 18/08/2020 -0400, David Stuhr wrote:
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?
Yup. You can suggest enhancements
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
They updated my email servers and they have decided that any document with a
macro is invalid / dangerous. Will see if I can fix it or if I need to have the
admin to id. It was fixed a few months back, but the server was updated. They
are just trying to keep me safe Hate that to some
Yeah, it would not send. Not sure if my server rejected the email, if his
server rejected my server, etc. I need to look into it.
On Tuesday, August 18, 2020 18:37 EDT, Steven Ahlers
wrote:
Andrew you need to remove the .INVALID from the end of his email address.
Sent from my iPhone
> On
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 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
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
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
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
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
Hello,
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
11 matches
Mail list logo
