problem with saving

[poperinge]

Hello Dave,

Thanks for your quick reply and feedback. I tried it and indeed I don'
get the messagebox "Excel recalculates formulas ....". As noted in th
Google Groups- thread I still get the normal messagebox "save changes
which I still manually have to confirm in order to get the correct dat
read back to my application.
So I am now looking if I can set some parameter in the registry tha
does this automatically.


thanks again
Stefaa

 

[Dave Peterson]

I'm not aware of any other tweak to the registry.

But if you're opening the workbook to use a calculator, you could just close the
workbook without saving:

dim wkbk as workbook
set wkbk = workbooks.open(filename:=....)
'do you manipulation
wkbk.close savechanges:=false
set wkbk = nothing
....