Export to Excel without opening File (1 Viewer)

[Drevlin]

As the subject says I'm looking to export a file to excel.

I'm currently using:
DoCmd.OutputTo

This, however, opens the file in Excel. Is there some way of exporting to Excel without it directly opening the program?

Thanx in advance.

 

[[nateobot]]

Not that i know of.

You could always set it to false so that the user does not see Excel being opened.

DoCmd.OutputTo acReport, "rptTest", "Microsoft Excel (*.xls), RptPath, False

 

[Drevlin]

That's exactly what I was looking for. I was just being brain dead.

Thanks.