Hi all,

I'm attempting to write a module to export a table (selected by a user in a form).
I would like the user to define the export format as well. Is there an opportunity to start the export dialog (handover of table to be exported)?

From my point of view, I cannot use the method transferSpreadsheet due to the export format should be defined by the user. (additionally the options of acSpreadsheetType are much more limited compared to the original opportunities in the dialog)

Of course there is the command in the menu, but I would like to start this command without using the menu.

Does anyone has a good ideas? I'm apprciate any help.

regards
Anders

you are probably better exporting a query, as you can include related tables (eg where the base table stores a key to a foreign table, the key is probably not as informative as the lookedup value), and you can sort/filter the query

if you use transfertext you can design a specification file that manaes the formatting of each of the fields in the query, and actually generates a csv, rather than a excel sheet directly (there are other formats, but a csv is good for most things)