Re: [libreoffice-users] Re: Acess2Base

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: users+unsubscribe@global.libreoffice.org
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