saving temp copy of excel workbook

Add-in Express™ Support Service
That's what is more important than anything else

saving temp copy of excel workbook
 
Phillippe Allen




Posts: 30
 Joined: 2005-11-07
I am using the SaveCopyAs method to save a temporary copy of the active workbook. The problem I am having is that if the user has just typed some text into a cell but hasnt committed the changes (eg hit return or changed focus to a different cell), then the method fails. I am assuming this is because Excel has locked the workbook whilst the changes are being made. How do i commit the changes so that SaveCopyAs will work.

I have tried various options such as selecting a different cell or Calculate but I mustn't being doing this correctly because they are not working.

Regards
Phil
Posted 29 Jun, 2006 20:34:12 Top
Dmitry Kostochko


Add-in Express team


Posts: 2880
 Joined: 2004-04-05
Hi Phil,

Sorry, but we provide consulting on using MS Office objects, their properties and events for premium subscribers only.

Posted 30 Jun, 2006 05:51:36 Top