I have a TransferSpreads heet action in my macro where I
want to export the results of a select query into excel
10 named "Query1". I type in the name of the query into
the "table name" field and I type the file name of the
excel spreadsheet into the file name field.
However, when the macro runs, I get an error that the
database engine can not find the object "Query1".
What I am I doing wrong here?
I know that a select query can be used in a macro in this
way....
-andy
want to export the results of a select query into excel
10 named "Query1". I type in the name of the query into
the "table name" field and I type the file name of the
excel spreadsheet into the file name field.
However, when the macro runs, I get an error that the
database engine can not find the object "Query1".
What I am I doing wrong here?
I know that a select query can be used in a macro in this
way....
-andy