Murray Brown
asked on
Access VBA export query to Excel file without a file/path
Hi I am getting the error "The action or method requires a file name argument" in the following
DoCmd.TransferSpreadsheet acExport, , "q_TransferTransactions", , True
Is it not possible to just export the query so that it opens in Excel?
DoCmd.TransferSpreadsheet acExport, , "q_TransferTransactions", , True
Is it not possible to just export the query so that it opens in Excel?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks very much John
ASKER