I have 5 forms that come from 5 different queries. I would like to export the
data from the forms to the same excel file, as 5 separate worksheets.

Right now, i have a macro that runs:

OutputTo -- and this takes care of the first form

To have all of these form appear on the same file, i read here that i can
use the "Transferspreadsheet" to export the rest of the forms....i tried to,
but apparently, i can only transfer queries and tables. Is it even possible
to use "Transferspreadsheet" for forms? If so, how do i do it? And if not,
what other methods should i use?

Any help is appreciated!!

Check out.

http://www.datapigtechnologies.com/freeware.htm

DataPig Access Explosion

lay wrote:
> I have 5 forms that come from 5 different queries. I would like to export the
> data from the forms to the same excel file, as 5 separate worksheets.
>
> Right now, i have a macro that runs:
>
> OutputTo -- and this takes care of the first form
>
> To have all of these form appear on the same file, i read here that i can
> use the "Transferspreadsheet" to export the rest of the forms....i tried to,
> but apparently, i can only transfer queries and tables. Is it even possible
> to use "Transferspreadsheet" for forms? If so, how do i do it? And if not,
> what other methods should i use?
>
> Any help is appreciated!!