View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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?