Statement Converter > Statement Converter Support > Knowledgebase

Search help:

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."

Error 1004

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.

Was this article helpful? yes / no
Related articles Runtime error '13' (when editing a config file)
Error #53 or Error #75 when editing/saving a config file
Runtime error '13' (when converting)
"Can't change account type"
Where to put settings -- 'System' or 'Statement' config file
Article details
Article ID: 57
Category: Using the Converter
Rating (Votes): Article rated 3.0/5.0 (45)

« Go back

Powered by Help Desk Software HESK, in partnership with SysAid Technologies