Changing Worksheet State completely
 

Hi,

Using the PIAs I am exporting a third-party grid to Excel from .Net.

The grid's export functions require an Excel sheet to be saved as a file --
there's no way to save it as a stream or load it directly into Excel. So I
then invoke Excel and bring up the saved file. But I would like the user to
see the worksheet as if it were completely new, unsaved, so they can choose
their own filename and not have to click 'save as...'

Is there any way to do this?

Changing Worksheet State completely
 

Try saving the file as an xlt (Excel template) file. Excel should prompt for a filename when the
user first saves it.

HTH,
Bernie
MS Excel MVP


"huysmans" wrote in message
...
Hi,

Using the PIAs I am exporting a third-party grid to Excel from .Net.

The grid's export functions require an Excel sheet to be saved as a file --
there's no way to save it as a stream or load it directly into Excel. So I
then invoke Excel and bring up the saved file. But I would like the user to
see the worksheet as if it were completely new, unsaved, so they can choose
their own filename and not have to click 'save as...'

Is there any way to do this?