Bill Chmura wrote:
On Sat, 22 Jul 2006 07:39:49 -0400
"G. Roderick Singleton" <[EMAIL PROTECTED]> spake:
[whole bunch snipped]
No VBA was included. So GetZip and GetAddress are not there for
analysis or recommendation on how to translate them. If it will help get
everything into OOo, have a look at
http://documentation.openoffice.org/HOW_TO/various_topics/VbaStarBasicXref.pdf
and it companion example file.
So, I think I interpret your original question as that you want the
hyperlinks in a database of sorts. So now that I have the example, I
will see if there is a solution that I can find. May take a bit so be
patient. One other thing, do you care which database? I have Base,
Mysql, Postgres and Oracle with which to play.
Thanks for any help...
Basically oocalc just errors on every time the function is called in
the sheet.
Not surprized about the VB failing. Remember OOo uses OOoBASIC and
therefore any macros need some recoding. Staroffice may have a VB
migration tool if you are in a hurry.
Not sure about the VBA... that is the same copy that I load in Excel
and it works. I think the VBA may have been in a module attached to
the sheet - not sure if that helps.
All I need is a way to export the hyperlinks (not the "hypertext") into
CSV. From there I have a bunch of preprocessing in perl to do. If you
can get me that far, I'd be sure to put you on the christmas card and
unwanted fruitcake list for this year :)
I'll also take a look through the docs you pointed out
Thanks much,
Bill
Here is one more document:
http://files.ellisons.org.uk/OOo/OOoBasicVBAcomparisonV0.D.odt
This document is under construction and is not really meant for broader
use, but I was impressed with it.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
