Export To Excel

[Guest]

I am currenlty exporting a dataset to Excel using the OutPut to command and
it works fine.

When this is done it "forces" the user to save the file before opening it. I
would like to open it in Excel without saving the file. (Saving the file
seems to be causing confusion because it wants to overwrite the last file
they saved and my users do not like this)

Can opening in Excel without saving be done? Should I use a different method?

Thanks for you help.

 

[Guest]

Use TransferSpreadsheet to export data to Excel. It is much more suited for
it. If you specify a file name for the spreadsheet, it will overwrite the
file that exists, so you will have to take that into account.
The TransferSpreadsheet does not open the Excel file. You will have to use
either the Shell command or the FollowHyperLink method.