DoCmd.OutputTo

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
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exporting subform data 1
Exporting multiple queries to multiple sheets within one excel fil 2
export form to Excel limiting records 3
Export to spreadsheet error, help please 2
Export Subform to Excel and open 1
Using OUTPUT TO in VBA, then how to modify the XLS from Access? 2
Too many rows to Output 4
Specifying the file name from a form when using Outputto method 2

Top