Recent content by Bestse
-
B
VBA to export query to Excel and open Excel without saving
If you use OutputTo the final True indicates to open the Excel File after Creating it. DoCmd.OutputTo acOutputQuery, "YourQueryName", acFormatXLS, "FilePath and FileName" & ".xls", , True