| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
swap contents for one workbook with contents from another one
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
--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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
Can't you just save the New workbook with the same name as the Old workbook?
If you really want to copy/paste, this is an excellent starting point: http://www.rondebruin.nl/ado.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
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. "ryguy7272" wrote: Can't you just save the New workbook with the same name as the Old workbook? If you really want to copy/paste, this is an excellent starting point: http://www.rondebruin.nl/ado.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bug Repro" wrote: 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. "ryguy7272" wrote: Can't you just save the New workbook with the same name as the Old workbook? If you really want to copy/paste, this is an excellent starting point: http://www.rondebruin.nl/ado.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
swap contents for one workbook with contents from another one
Thanks for the pointer. I will try them out.
"ryguy7272" wrote: 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--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Bug Repro" wrote: 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. "ryguy7272" wrote: Can't you just save the New workbook with the same name as the Old workbook? If you really want to copy/paste, this is an excellent starting point: http://www.rondebruin.nl/ado.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to swap the contents rows and columns in a spreadsheet? | Excel Worksheet Functions | |||
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
| How to swap contents between 2 cells in MS Excel 2003? | Excel Discussion (Misc queries) | |||
| Is there an easy way to swap the contents of two cells in Excel? | Excel Discussion (Misc queries) | |||
| Swap contents of two cells | Excel Discussion (Misc queries) | |||
Linear Mode
