Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
How can I show state-by-state data (as silos) on a map of NA | Charts and Charting in Excel | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Changing The Changed State | Excel Programming |