I would like to call customised view and ex****t to excel file for
users to use. However, users have the right to choose what field
should be shown and what table should be included.
Problem comes. Although I can compose the SQL in VBA, however, I
cannot ex****t a excel file from a SQL statement or a recordset.
Anyway I can do so? I cannot ex****t a query or a table because the
query for users may different.