swap contents for one workbook with contents from another one

B

Bug Repro

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
 
J

Jacob Skaria

--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
 
B

Bug Repro

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.
 
B

Bug Repro

As I mentioned in an earlier reply, 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.
 
R

ryguy7272

You mentioned that in a reply 1/2 hour after I already posted my initial
response!! Anyway, go to this site:
http://www.rondebruin.nl/tips.htm

Look at the copy/paste/merge examples. I'm sure you can find something in
there that will do what you want to do.

HTH,
Ryan---
 
B

Bug Repro

Thanks for the pointer. I will try them out.

ryguy7272 said:
You mentioned that in a reply 1/2 hour after I already posted my initial
response!! Anyway, go to this site:
http://www.rondebruin.nl/tips.htm

Look at the copy/paste/merge examples. I'm sure you can find something in
there that will do what you want to do.

HTH,
Ryan---
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Swap the contents of one presentation with contents from another 1
Macro to copy table of contents to a new doc 0
How to swap the contents of a document with contents from another 1
Macro to Copy/Paste Multiple images 3
Recover Outlook calendar entry 1
VBA code for pasting links -- modifying RDB code for summary workbook 11
VBA to copy from one workbook into another 0
Adding Heading to Table of Contents after a column break 1

Top