Changing Worksheet State completely huysmans 27.09.2006 15:17:02 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?

Re: Changing Worksheet State completely Cindy M. <C.Meister-C[ at ]hispeed.ch> 28.09.2006 09:55:32 Hi =?Utf-8?B?aHV5c21hbnM=?=, [Quoted Text] > 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? > One way would be to display the Save As dialog box for them, as soon as they open the sheet. Another would be to open an empty workbook and dynamically transfer the data into it. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-)