conversion of xls files to mny files
ramon
files into mny files?
Dick Watson
The FAQ was revised based on a new tidbit posted in answer to this question
just this morning:
---
Q): How do I import from Excel (or .CSV or etc.)?
A): Money can only import QIF format data (or entire Quicken 2002 or earlier
files).
An Excel macro exists that can write .QIF format files from Excel.
Unfortunately, that macro is an old XLM style macro and that type of macro
has not been supported by Excel for many versions now. Microsoft has never
seen fit to issue any new capability like this.
Having said that, it is worth noting that QIF is just a text file with a
format that is not, apparently, all that complex. It should be reasonably
straightforward for someone used to mucking around in VBA for Excel to write
code to generate passable QIF files. The QIF file format is an ad hoc
standard semi-documented by Quicken. The references, all identified from a
search at google, may help you get there. There were many more references
that were not included here and these references may not be good currently.
If you create some code for this, please report back here and offer it up to
the community.
One reader, Didier Lachièze, has done just that. Several readers have
reported good results with Didier's macro.
Another reader, Ron Rosenfeld, reported on a shareware CSV to QIF converter.
There has been no other feedback on this tool.
Chris Cowles reported yet another CSV to QIF converter--built to go with a
personal finance manager application for Palm, the web site for which
provides yet another spin on QIF documentation.
References:
MSKB: Q077220 Excel to .QIF macro
<http://support.microsoft.com/default.aspx?scid=kb;en-us;Q77220>
google.com <http://www.google.com/>
QIF documented <http://www.respmech.com/mym2qifw/qif_new.htm>
QIF documented maybe a little less well
<http://www.intuit.com/support/quicken/2002/win/1181.html>
QIF Apple-centric documentation, but maybe still valid
<http://www.malcolmadams.com/te/info/qif00.shtml>
QIF documented by the GnuCash folks
<http://www.gnucash.org/docs/C/xacc-qif-import.html#QIF>
Didier Lachièze's Excel to QIF macro <http://xl2qif.chez.tiscali.fr/>
Another attempt to document QIF
<http://www.ntlug.org/~cbbrowne/financeformats.html>
CSV to QIF shareware <http://www.monthtwosys.co.uk/>
CSV to QIF revisited <http://matirelire.conduite.free.fr/ToQIF.zip>
QIF documented yet again and app for Palm
<http://www.scoubidou.com/MaTirelire/index_en.html>
"ramon" <sim...@hotmail.com> wrote in message
news:1da801c2b739$661eab20$8af82ecf@TK2MSFTNGXA03...