Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
replace state names with state code abbreviations se7098 Excel Worksheet Functions 3 July 25th 09 06:41 PM
How can I show state-by-state data (as silos) on a map of NA Rob Charts and Charting in Excel 0 November 5th 07 03:41 PM
Converting State Names to State Abbreviations aznate Excel Discussion (Misc queries) 1 October 20th 06 06:52 AM
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. [email protected] Excel Discussion (Misc queries) 0 September 22nd 05 04:39 PM
Changing The Changed State Gjones Excel Programming 2 May 20th 04 12:47 AM


All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"