I have 4 reports which I want to output to an excelsheet. I can do this either trough a macro or in VB. I already tried to do it in a macro but the problem is that when it starts to export the second report it wants to overwrite the excel sheet that has been created ( in stead of just adding teh data to a different worksheet which is what happens if I export a table or query)

Now I'm tryng to do it in code but I end up with the same problem.
For the first report the code looks like this:

Public Function test()
DoCmd.OutputTo acOutputReport, "report1", acFormatXLS, "c:\test.xls", False
End Function

It might help if I was able to also specify the worksheet it has to output to but I don't know if this is possible and if this is possible how to do it.