Hi,
I have a form with subform.
The User selects tick boxes on the form relating to the columns of a data sheet (subform) they want to display. Pressing update refreshes the data sheet view.
I use the 'columnhidden' attribute to hide/display the columns.
What I want is to be able to export the chosen columns to a .xls spreadsheet.
How do I do this?
Should I export the data sheet or can I hide/unhide columns in the query using VB/VBA.
Any help would be good.
Using 2003 on XP.
Thanks in advance.
I have a form with subform.
The User selects tick boxes on the form relating to the columns of a data sheet (subform) they want to display. Pressing update refreshes the data sheet view.
I use the 'columnhidden' attribute to hide/display the columns.
What I want is to be able to export the chosen columns to a .xls spreadsheet.
How do I do this?
Should I export the data sheet or can I hide/unhide columns in the query using VB/VBA.
Any help would be good.
Using 2003 on XP.
Thanks in advance.