CODEWITHSUNDEEP
c#excelprocess
Marcom
Marcom

Reputation: 4741

How can I force the user to save an excel file in excel?

I am create an .xls file programatically and opening it in excel

for example:

Process.Start("c:/blabla.xls");

I am deleting the file when excel is closed, so I would like to prompt the user if he wants to save the file when excel before it is closed, and ideally make him save it to a new location.

I'm hoping there is an argument I can feed to excel during the Process.Start

Upvotes: 3

Views: 1619

Answers (2)

Heinzi
Heinzi

Reputation: 172220

Instead of opening Excel with an Excel file (.xls), you could open Excel with a Excel template (.xlt). This should open a new, unnamed file in Excel, using your xlt as the template. Since the file is unnamed, the user will be prompted to choose a location and file name if he made any changes.

(I'm not sure if renaming the file suffices; you might have to save the file as a template.)

EDIT: In fact, there is a command-line switch lets you do exactly that (open a normal Excel file as a template):

excel.exe /t C:\blabla.xls

Upvotes: 4

ChrisNel52
ChrisNel52

Reputation: 15133

Handle the BeforeClosed event.

This is assuming you are using Excel automation. Which, after reading your question again it appears you are not.

http://j-walk.com/ss/excel/tips/tip78.htm

Upvotes: 2

Related Questions