Again, thanks Jim for your comment and the 2 interesting links.

I had to recognize that we need to get professional support of a BASE and CALC expert and hope that this expert knows if a BASE DB with macros for data export into CALC will run on W7 and Linux.

Regards, Reinhold

On 2014-08-11 11:18, Jim Byrnes wrote:
On 08/10/2014 08:02 PM, rost52 wrote:
Thanks Jim for introducing this topic.

A small company I know is using an ACCESS DB with macros exporting
certain information into EXCEL spreadsheets. This ACCESS DB is currently
preventing the company to change over  from MSO to LibO and Linux.

A 2 step approach is discussed: First to migrate from MSO to LibO using
W7 and second moving from Windows to Linux. (Distributions not yet
decided but most likely Linux Mint of Linux Mint Debian or Antergos.)

Therefore, 1 more question from my side: Assuming that using Access2Base
helps us to get the DB and the macros into Base and create the Calc
spreadsheets, can this BASE DB with the LibO macros be used as they are
when changing from W7 to Linux?


I don't know. I just discovered it a few hours ago. My impression is that it lets people that know how to write macros for Access use a syntax they are similar with to write macros in Base. I could be wrong.

Here is a link to the website:

http://www.access2base.com/access2base.html

Here is a link to an OpenOffice discussion forum about it:

https://forum.openoffice.org/en/forum/viewtopic.php?f=47&t=61447

HTH

Regards, Jim

On 2014-08-11 06:47, Jim Byrnes wrote:
I am still using the 3.xx version of LO that came with Ubuntu 12.04
and haven't been on the main LibreOffice site for some time. I've
been reading the naming discussion (Fresh/Still etc)  and decided to
look at the site.  While there I stumbled across Acces2Base. I've
always thought writing macros in LO was way harder than it should be
because of UNO, so this is an interesting development.

A couple of questions:

(1) Has anyone here used it and does it make writing macros for Base
easier?

(2) I write most of my macros for Calc  so is there a Excel2Calc planned?

Regards,  Jim









--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to