That is a solution, however, from a users point of view it is less then
ideal. I am looking for a solution which allows a better user experience if
possible.

"Jacob Skaria" wrote:

--Set screen updating to false
--Close the current workbook.
--Create a copy of backup file and save as current file (overwrite)
--Open the file

If this post helps click Yes
---------------
Jacob Skaria


"Bug Repro" wrote:

Hello

I am creating a solution in which I need to swap the contents of an existing
workbook with contents from a backup copy. The destination workbook
is in open state before this operation starts. What I am thinking of is to
copy and past of all the worksheets from the backup to the
destination and delete all the original worksheets from the destination, and
then
saving the destination document. Is there a better option? We want to make
the user experience as smooth as possible. Ideally, the view state of the
destination will be preserved as is.

I need to do this for Excel 2003, and 2007. Please let me know what the best
approach would be.

Thanks