Knowledgebase
Statement Converter > Statement Converter Support > Knowledgebase

Search help:



Run-time error '1004' in SetLookupTable

Solution

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
Article details
Article ID: 57
Category: Using the Converter
Rating (Votes): Article rated 2.9/5.0 (25)

 
« Go back

 
Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid