The two options appear to be essentially the same but provide completely different abilities.
Using “Save” the user cannot define the column order unless using the option from within <Table> view in which case the order is as displayed and can be reordered. However, if used from <Form> view the order appears random and not as listed in Table view or in tab order. Would it not be better to use the order from table view irrespective of where it is called from?
I can see that “Save” from the file menu is useful for ad-hoc exports but I do not see its usefulness in scripts, where “Export” is the better option.
There are however a couple of options not provided in “Export” which would be useful,
- Allowing the output file to be a calculated path.
- Placing the calculated Excel “Name”, which can include search criteria, in the $A$1 cell and placing the export from line 2 or 3.
- An option to exclude the table name from the column headers
Is this a fair summary or have I missed something important?