E
Eddy
Dear all,
I have a Main form and a subform, where the subform is in datasheet view.
I want to export the data in subform to Excel after setting the criteria in
Main form and adjusting the format in subform (reorder, hide and resize the
columns).
If I open the subform alone (not in Main form), then I can use the Export
command to export the data to Excel. But, I cannot do it when it is a subform
in Main form. OutputTo command cannot export the new format of the subform.
Even I use OutputTo with the subform, it cannot generate the Excel with
update RecordSource and the new format.
I also build the query and then use TransferSpreadsheet method, but the
format of the subform (set by user, may be reorder or hide columns) cannot
display on the query.
Please help!!
Eddy
I have a Main form and a subform, where the subform is in datasheet view.
I want to export the data in subform to Excel after setting the criteria in
Main form and adjusting the format in subform (reorder, hide and resize the
columns).
If I open the subform alone (not in Main form), then I can use the Export
command to export the data to Excel. But, I cannot do it when it is a subform
in Main form. OutputTo command cannot export the new format of the subform.
Even I use OutputTo with the subform, it cannot generate the Excel with
update RecordSource and the new format.
I also build the query and then use TransferSpreadsheet method, but the
format of the subform (set by user, may be reorder or hide columns) cannot
display on the query.
Please help!!
Eddy