Can you export two reports to the same Excel file?

  • Thread starter Thread starter larochy
  • Start date Start date
L

larochy

Hi,

Is it possible to export two reports into one Excel file, each on it's own
tab in Excel? I would assume there's some vba code to do this but I'm not
sure, any help would be appreciated.

Thanks
 
Not for a report there is not. I never export reports to Excel. They always
look funky.
There is a way to create the Excel file you want, but it would not involve a
report. That would be to use Automation to create the Excel file and put the
data in it using Automation. Be prepared for a lot of code. The Excel
Object Model is huge and detailed.
 
Back
Top