GNUCash Import QIF - Help Please!

[GT-I9070 H]

Thanks for the tip Allan!

I tried using this macro xls2qif but it did not work for me in MS Excell
2013 so I wrote a XLSX2QIF that works very well.

And the problem is not with the macro or the .qif file. The problem is with
the GnuCash importer.

Regards
GTI

2015-06-23 16:30 GMT-04:00 <allanhasmail at gmail.com>:

> Isn't the xls2qif macro a good tool for this?
>
> I haven't been following to closely, but I got it working by bypassing the
> macro security preferences.
> --
> Allan
>
> Derek Atkins <warlord at MIT.EDU> wrote:
> >David,
> >
> >David Carlson <david.carlson.417 at gmail.com> writes:
> >
> >> On 6/22/2015 10:25 PM, GT-I9070 H wrote:
> >>> Hi David,
> >>>
> >>> Thanks for the tip!
> >>>
> >>> But I do not want the Internet exchange rates, I want to exchange
> >>> rates (currency prices) that I practiced on that date in every
> >>> transaction that I have written in an MS Excel spreadsheet.
> >>>
> >>> Regards
> >>> GTI
> >>>
> >>
> >> I am still not fully understanding what you are looking for.  If a
> >given
> >> transaction involves two (or more) currencies, it will have an
> >inherent
> >> exchange rate which should be correct therein if it is entered
> >> correctly.  I.e., if I buy a bag of candy marked US$5.00 and pay for
> >it
> >> with a certain number of Euros, there is an exact exchange rate
> >within
> >> the transaction.
> >
> >What he's looking for is a way to *import* these transactions.
> >
> >Sure, he could enter them into the register, but he's (for some reason)
> >already entered them into some other spreadsheet program and wants to
> >import them into Gnucash instead of re-keying them into the Gnucash UI.
> >
> >AFAIK, none of the importers will do that.
> >
> >> Please remember to CC this list on all your replies.
> >> You can do this by using Reply-To-List or Reply-All.
> >
> >-derek
> >--
> >       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >       Member, MIT Student Information Processing Board  (SIPB)
> >       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >       warlord at MIT.EDU                        PGP key available
> >_______________________________________________
> >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.
> _______________________________________________
> 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.
>