One click export from spreadsheets to GnuCash

[One Click To Qif]

Hi Tommy:

Yes I put there a lot of work, first for having it running for my own
use, then for making it generic at documented for general use.
Thanks for taking the time to test it and commenting the results.

First, the good news.
I think you should be able to easily get it running in OpenOffice Calc:
just don't click those buttons you mentioned; write the path to the
export folder in the green cell, and click the "Export" button. I
think(*) macros associated to this button are not Excel Windows
specific.

- "Select folder" button is just a help to not manually write the
folder, which is a one-time task
- "Format tabs" is just an utility to (conditional and normal) format
all the spreadsheet tabs.

(*) I have never used OpenOffice neither LibreOffice, and I did not
know they can execute Excel macros without much effort to translate
the programming language. I was planning to install them and translate
the macros, but as I derive from your mail they can execute VBA code,
so my guess is the examples can work just writing the folder and
clicking the "Export" button, which macros are not system specific.
Let me know if you can test that; in any case I will be installing
OO/LO and testing myself, and also trying to get the other utility
buttons to work.

You are right, I just did not identify the project as MS-Windows
specific as I did not figure out someone could try the .xlsx files on
OO, and I planned later OO versions. Now I am not sure if I should
create two different versions, or as you said, I should just use more
generic VBA functions.

On Sat, Mar 12, 2016 at 1:29 AM, Tommy Trussell
<tommy.trussell at gmail.com> wrote:
> 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.
>
>