[AccessD] Code to Copy a query to Excel and Open said file?

Stuart McLachlan stuart at lexacorp.com.pg
Sat Mar 4 01:28:48 CST 2006


On 3 Mar 2006 at 23:32, Arthur Fuller wrote:

> I want to open an Access query and have its contents sent to an Excel file,
> and have Excel open automatically with said file visible. 

DoCmd.OutputTo acOutputQuery, "qryTest", acFormatXLS, "Test.XLS", True-- 
Stuart





More information about the AccessD mailing list