Exporting Form Records to Excel

[Jeff]

Hello,

I know that when you have a Form that display records, there is a Analyze
With Excel Toolbar that when you click on it, it exports the info to Excel.
I like the way this works. I especially like how it will only export the
Rows that you highlight.

However I now have a main Form that is unbound and have a subform on it that
has the data. When I now click on this Toolbar it exports the info from the
Main Form not the subform with the Records. I also tried adding these
Toolbars to the ShortCut Menu of the Subform and still when you click on it
there it exports the Main Form info.

How can I get it to work that it Exports the records from the subform and
again so that it only exports the Rows I highlight.

I also tried DoCmd.OutputTo acOutputForm, "subfrmContracts", acFormatXLS,
"C:\Test.xls", True

This will Export out all the subfrm records not the ones I highlight.

Any help would be greatly apprecaited.

Thank you,
Jeff Anteby

 

[Sam]

Hi Jeff,

I'm still new to Access, but i can leave an idea or two untill one of
the bigger boys can give you a better one

At this stage you can now export the subform, but you want to refine
this to exporting only the highlighted items?

Would one possible solution to consider be possibly creating a
recordset that holds the highlighted items, then exporting this?