ConverExcel2TXF - Frequently Asked Questions   

Below you'll find some answers to frequently asked questions. If you don't see an answer to your particular question or problem, just shoot me an email and I'll get back to you as soon as possible.

1. I get an error that states "compile error in hidden module: frmGenTXF".
2. I get an error that states "type mismatch".
3. My broker combines the quantity and symbol into the same column. Which columns should I select?
4. I paid via Paypal with a check, but I didn't get redirected to the download site. How do I get my download?
5. I use OpenOffice instead of Excel. Can I still use this program?

1. I get an error that states "compile error in hidden module: frmGenTXF".
You need to have at least Excel 2000 running on a PC. It sounds like you're either using an older version of Excel, or a Mac version. If you don't have at least Excel 2000 running on a PC, try instead our ConvertCSV2TXF program, which is a stand-alone java executable that will run on any platform. If you've already paid for the program, send me an email and I'll send you a copy of the stand-alone java version.

2. I get an error that states "type mismatch".
A "type mismatch" error means that there is a problem with the format of one or more of your dates. Try this: select both date columns (just hold down the ctrl key and click the two column headers). Then from the main menu select "Format" -> "Cells...". In the "Number" tab, select "Custom" from the "Category" box, then type "mm/dd/yyyy" in the "Type" box and click "OK". If you still get a type mismatch error, email me your Excel file (be sure to delete any sensitive information first- account number, etc) and I'll run it through the debugger.

3. My broker combines the quantity and symbol into the same column. Which columns should I select?
If the quantity and symbol are combined in the same column, just leave the "Quantity Column" box empty.

4. I paid via Paypal with a check, but I didn't get redirected to the download site. How do I get my download?
When you make a Paypal payment with a check, it remains uncleared for 3 or 4 days. If you want your download right away, just send me an email.

5. I use OpenOffice instead of Excel. Can I still use this program?
For the ConvertExcel2TXF macro, you need to have at least Excel 2000 running on a PC. If you don't have at least Excel 2000 running on a PC, try instead our ConvertCSV2TXF program, which is a stand-alone java executable that will run on any platform. If you've already paid for the program, send me an email and I'll send you a copy of the stand-alone java version..