TransferSpreadsheet just dumps the data into excel w/o formatting
while the ExportExcel command (w/ ribbon) brings up the wizard to
select the name, destination and an option to format the file.

I want the user to be able to export to excel w/ this wizard but he or
she won't be able to select it from the navigation pane because it
will be disabled. Is there a way to select which query to export and
to launch the ExportExcel wizard w/ vba?

Only other option is to create a custom nav pane for the user

I see there is a way to launch idMso;

Application.CommandBars.ExecuteMso(“Copy”)

but

Application.CommandBars.ExecuteMso(“ExportExcel”)

is giving 'invalid procedure call or argument'. As well, no way to
select the object to call the command on...


Thanks