DoCmd.OutputTo

  • Thread starter Thread starter TAMMY
  • Start date Start date
T

TAMMY

If I use the OutputTo command to output information on a
form to an excel file, it disables or doesn't run any
code that I have on the Workbook_Open()event of the excel
file. Does anyone know why?

Code below:

DoCmd.OutputTo acOutputForm, "Form Name",
acFormatXLS, "Excel File Name", False
 
Hi Tammy,

As far as I can tell, OutputTo creates an entirely new Excel file every
time. If you use the name of an existing file, this is overwritten along
with any macros it may contain.
 
Back
Top