output to excel form AND subform??

[keiserc]

Have a form with subform. have command button which runs macro output to excel. HOW do I output the data on the subform at the same time to the same spreadsheet????

 

[faeryfyrre]

I don't think the Macro 'Output To' is powerful enough to work on Subforms. You will probably have to ditch that approach altogether and change to performing the Output via VBA code.

If you want the Subform Data to be output to the same Worksheet as the mainform Data then that will be a little trickier still - you'll have to learn how to use the Excel Range object.

There are plenty of threads that deal with this topic.

Alec Doughty
Doughty Consulting P/L

"Life's a competition. Play hard, but play fair"

 

[PHV]

You may consider to build a report.
Or create a named query and pull data from within excel

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884