The macro runs without any error message but not QIF ouput file is generated:
Check if the macro execution is allowed by your antivirus software
(this issue has been reported with the Kaspersky Office antivirus).
The decimal separator is lost during the conversion (an amount of 100,00 becomes
10000):
This issue has been reported with some versions of Money 2000 who don't recognize the
point "." as the standard decimal separator in the QIF file.
As a workaround for this issue the revision 0.9 of xl2qif includes a special processing
to replace in the QIF output file the point "." by the comma "," as the decimal separator.
When I import from QIF to Money, Money does not include the categories:
This a Money issue, I've observed that to import categories from a QIF file,
you have to choose under Money the command File>Import... import as a new account.
Otherwise, with the default import settings the categories are not imported
even if they are present in the QIF file.
Error messages
I get the error message "Invalid values in Date column":
This occurs when one of the selected cells in the Date column as defined by the fields order
has a value which is not recognized as a valid date by Excel.
This error can be due to:
an error in the definition of the fields order for the data to convert
an error in the selection of the data to convert: for example the selection of the
title of the columns (see Excel data organisation)
I get the error message "Invalid values in Amount column":
This occurs when one of the selected cells in the Amount column as defined by the fields order
has a value which is not recognized as a valid number by Excel.
This error can be due to:
an error in the definition of the fields order for the data to convert
a difference between the decimal separator in the cell and the local settings of the
PC: for example a value of 100,00 in the cell with the point "." selected as the decimal
separator in the local settings.