DoCmd.OutputTo - Stop excel form opening

tgleghorn58

Registered User.
Local time
Yesterday, 19:28
Joined
Sep 9, 2014
Messages
26
I am saving an access table to excel, which is working however the excel opens also and I do not want it do. This is my vba

DoCmd.OutputTo acOutputTable, "tbl_reduction", "ExcelWorkbook(*.xlsx)", RptName, True, "", , acExportQualityPrint

Beep
MsgBox """File has successfully been saved. Open up excel template 'Tracking Grid TEMPLATE.xls' refresh data. then save to file name preferred!.""", vbOKOnly, ""
 

Users who are viewing this thread

Back
Top Bottom