Exporting subdatasheet

[DHIGHTO]

Hey,

I know I can't export subdatasheets into excel. Are there any good links for a VBA code I can use as a template? Are there any good work arounds? I was there was a addon called A2EE that exports the subdatasheets. Has anyone tried this?

Thanks

[June7]

Can export any table or query you want.

Never heardof A2EE.

[DHIGHTO]

I'm refering to queries with a subdatasheet. I like the format.

[June7]

Well, regardless, don't think it's going to happen. Can try exporting report/subreport but that often doesn't look nice in Excel, especially if report has grouping setup.

Could probably export a query that joins the parent and related subtable. That should be the easiest and the result should be a conventional spreadsheet.