Export 3 Access Reports to 1 Excel Doc - Cmd Button

[Robby19]

So currently, I have 3 command buttons with the following code;

Private Sub Command368_Click()
DoCmd.OutputTo acOutputReport, "Visit Report By PMCC", acFormatXLS, "c:\Exports\Visit Report by PMCC.xls", True
End Sub

Is it possible to export 3 reports into 1 excel doc and have each report in a different tab?

 

[alansidman]

Look at this blog

http://accessblog.net/2006/07/export-to-excel-range.html

 

[Robby19]

I am a rock when it comes to VBA, but if I understand that first paragraph clearly it says that the TransferSpreadsheet code is not used for Exporting only Importing. I don't believe this would be the answer, unless you know something I don't which is most likely the case.

 

[alansidman]

If you read on beyond the first paragraph, the blogger gives you code to do what you want. He is giving you background on what MS says and what is reality. Don't give up complaining, try the code that is given.

 

[Robby19]

Will do! Thank you for the continued support.