Two separate reports into one excel document (1 Viewer)

[DenisCooper]

Hi,

I have two reports which are generated when i click a button in a form. The reports work fine by themselves, but i'd like to import the data into excel automatically, so when i press the button on my form it creates a new excel document with two tabs, the first tab with the first report and the second tab with the second report.

Im not great in VBA so any help greatly appreciated.

Thanks

 

[Trevor G]

If you create a temp folder and workbook for the data then use 2 macros to TransferSpreadsheet to that workbook they will go on separate worksheet tabs, that would be the easiest way.