Run-time error '1004' in SetLookupTable
Error message: "Error #1004 in SetLookupTable. Excel cannot access 'Quickbooks Statement Converter'. The document may be read-only or encrypted."
Issue: Excel cannot open the Lookup table.
Reason: The path to and/or name of the table is incorrect in the conversion settings.
Solution: Verify that the PATH and FILENAME are correct in the conversion settings.
How to: View and edit the setting from the menu (Convert to QB > View config...) or by manually opening the config file (SC_config_XYZ.txt) with a text editor such as Notepad.
After making any changes, SAVE the changes and re-convert the statement.