One click export from spreadsheets to GnuCash

[One Click To Qif]

Hi Larry:

Thanks for the tip, I am doing a Libre Office version

On Sat, Mar 12, 2016 at 2:41 PM, Larry Evans <cppljevans at suddenlink.net> wrote:
> On 03/11/2016 06:29 PM, Tommy Trussell 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
>>>
>>>
> [snip]
>> 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.
> [snip]
>
>> 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.)
>>
> +1
>
> Since libreoffice can convert its spreadsheets to excel, just use
> libreoffice to provide an excel version of your spreadsheet for
> those users who don't want to install the free libreoffice on
> their windows machines.
>
>> Otherwise, you might clearly identify your project as being for Microsoft
>> Windows and Microsoft Office only.
> +2
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.