G
Guest
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!!
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!!