One click export from spreadsheets to GnuCash

[Tommy Trussell]

On Tue, Mar 8, 2016 at 10:46 AM, One Click To Qif <oneclicktoqif at gmail.com>
wrote:

> I created OneClickToQIF: a freeware and open source
> project: with OneClickToQIF is very quick and easy to move data from
> spreadsheets to GnuCash or other bookkeeping application, using the
> former for insertion and some calculations, and the latter for all the
> functionality of a double-entry bookkeeping application.
>
> Github project:  https://github.com/OneClickToQif/OneClickToQif
>
>
I was impressed at how much work you put into your project! I am sure you
spent many hours making it work the way you expect. Despite reading some of
the documentation you provided, however, I didn't understand how it was
supposed to work, so I thought I would have a closer look.

I downloaded two of the spreadsheets from GitHub, and I was able to open
them with LibreOffice. Unfortunately they were not usable at all on my
Linux system.

For example, I opened accounts.xlsm then clicked the Select Folder button.
It generated an error:

BASIC runtime error.
> '73'
> Not implemented.


Clicking Format Tabs generated a different error:

BASIC runtime error.
> '423'
> FormatConditions


It looks like the VBA code includes Windows-only .dll functions (for the
file selector), so this alone would make the spreadsheets usable only for
Microsoft Excel in Windows. (I believe Excel on a Macintosh cannot use .dll
functions.)

To make your utility more widely available to GnuCash users, you might
research whether it's possible to use more generic VBA functions that can
run under LibreOffice. (LibreOffice and its cousin OpenOffice are open
source and freely available on Windows, Macintosh and Linux.)

Otherwise, you might clearly identify your project as being for Microsoft
Windows and Microsoft Office only.


-----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>