Can you export two reports to the same Excel file?

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
 
K

Klatuu

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export BPMN Visio Chart to Excel 0
Export tracked changes to a new document 0
Autonumber field in Excel that behaves the same as Access 0
Merging from an Excel file with graphics 1
Dumb question alert! What program to use? 0
Using Office Forms and dynamically updating the excel backend 0
VBA concatenate ranges into a new document 0
Embed the same Excel multiple times 0

Top