Problem with Selection.QueryTable.Refresh BackgroundQuery:=False

[BryanS]

I inherited an excel spreadsheet from a programmer who is now long gone. It uses a macro and ODBC to access some data on the AS/400. We recently merged 2 partitions on the AS/400 and the macro stopped working. I updated the ODBC configuration to point to the correct partition, but then the macro throws an error at the line

Selection.QueryTable.Refresh BackgroundQuery:=False

I get a Run-time error '1004' General ODBC error.

When I comment out the 'Selection.QueryTable' line the macro runs but the user says it returns no data.

I am flummoxed. Any help would be appreciated.

Bryan

[Tarball]

Add this to the code below your connection parameters. It will print out the exact ODBC error codes encountered

Please Login or Register  to view this content.