How to disable all forms of autosave for a certain workbook.

[Harvey]

Hi all,

I have ths problem:

Intro
I made an excel application that stores its data on the worksheet. When a user clicks save the data is exported to an xml-file. The application xls changes in the process, so excel tries to auto(save) it. I cannot have this happening. I do not want any messages pop up (this file is read only or cannot save), so I want to completely disable all kinds of autosave and autorecovery events.

Question
Can someone explain to me what autosave processes run during excel, and how to disable them. Note that other documents should autosave properly, even if they are opened at the same time as my workbook.

Other suggestions are welcome too, thanks in advance for any replies.

 

[erik.van.geit]

I think so

is this the purpose:
The user should only run the file with it's original name ?

 

[Harvey]

It is an application. The data the user inputs is first stored on worksheets, and later exported to xml files. When the application is closed it does not save so it remains in it's original state (worksheets for data are empty again)
On occasion, prices are changed and the workbook has to be saved manually, so I don't want to make it read-only.
Now autosave and autorecovery both save data that I don't want to be saved.
That's why I want to disable them.
Thanks a lot for the help to both of you, I think the problem is solved this way.

 

[Harvey]

hmm, I figured I still need something to cancel the "normal" autosave, since altering the beforesave event also cancels normal save. Any suggestions?

 

[erik.van.geit]

hmm, I figured I still need something to cancel the "normal" autosave

what do you call "normal autosave" ?
where do you set that ?

since altering the beforesave event also cancels normal save.

I don't understand the relation between first part of the question
and what do you mean by this second statement ?

 

[Harvey]

I believe Excel (2003) autosaves the documents every x minutes (default is 10). I want this to continue happening, except for my workbook.

But I am not sure if it actually happens, since I was not able to 'catch' excel autosaving yet (started this morning)

If you know how this autosave works and how it's interrupted, I'd like to hear because I'm still a bit stuck with it.

I think my program might be working properly now, but I don't wanna take the risk.

Thanks for the help so far, I hope you can help me with this one also.

 

[erik.van.geit]

the line I posted is about this feature you're talking about

ActiveWorkbook.EnableAutoRecover = False

tools/options: Tab "Save"

when you record a macro disabling the "autosave" you will get the line above

best regards,
Erik