Locking a worksheet during the reading of it
Hello All!
I have an Excel 2003 workbook that contains Exchange Rates that is
automatically updated by an external program. I have used VSTO 2005 to
create an application that reads the updated Exchange Rates and saves them to
a database using a webservice.
The problem that I'm having is that when I'm reading my values, if any of
the cells change, my application crashes. Is there a way to lock the values
of the worksheet so that they don't get changed while I'm trying to read them?
|