Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return WB to original state
Does anyone know of a way to:
1. After perfroming a lot of calculations in a workbook (well over 100 and to many to consider undo) 2. Keep/Save results (this only consists of 12 cells) 3. Get the WorkBook back to the original state. 4. Paste in the new results. Also; Can I "SaveAs" and keep the original WorkBook open and active? Can I create a Copy of an open WorkBook? As always, any help is appreciated. Regards Before I go to a lot of work trhrough a real roundabout method I am looking for someone |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return WB to original state
If you saveas, then your "original" workbook is no longer open. However, if
you saved the workbook before you did the calculations, you can then reopen it after the saveas. (Capture the current file location, saveas, then open the file that was previously open.) This would allow you to copy the "12" cells that have your new data, into your, "existing" workbook. Of course, then you may have to delete the "new" workbook, or just keep the calculation file around and handle saveas errors when they happen. I think this would be your best route pending better ideas. "Ronbo" wrote: Does anyone know of a way to: 1. After perfroming a lot of calculations in a workbook (well over 100 and to many to consider undo) 2. Keep/Save results (this only consists of 12 cells) 3. Get the WorkBook back to the original state. 4. Paste in the new results. Also; Can I "SaveAs" and keep the original WorkBook open and active? Can I create a Copy of an open WorkBook? As always, any help is appreciated. Regards Before I go to a lot of work trhrough a real roundabout method I am looking for someone |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return WB to original state
Thanks, this is within the realm of my workarounds. I was hoping for a
cleaner easier way. "GB" wrote: If you saveas, then your "original" workbook is no longer open. However, if you saved the workbook before you did the calculations, you can then reopen it after the saveas. (Capture the current file location, saveas, then open the file that was previously open.) This would allow you to copy the "12" cells that have your new data, into your, "existing" workbook. Of course, then you may have to delete the "new" workbook, or just keep the calculation file around and handle saveas errors when they happen. I think this would be your best route pending better ideas. "Ronbo" wrote: Does anyone know of a way to: 1. After perfroming a lot of calculations in a workbook (well over 100 and to many to consider undo) 2. Keep/Save results (this only consists of 12 cells) 3. Get the WorkBook back to the original state. 4. Paste in the new results. Also; Can I "SaveAs" and keep the original WorkBook open and active? Can I create a Copy of an open WorkBook? As always, any help is appreciated. Regards Before I go to a lot of work trhrough a real roundabout method I am looking for someone |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return WB to original state
Another option, would be to save your current copy
copy the original workbook. Open the new copy perform the calculations on the copy copy the new data to your original file close the copied file (one with the calculations) and then remove the copy. I guess another alternative depending on how many worksheets are involved and the way that your code is setup to work with the different worksheets, would be to copy the worksheet(s) on which calculations are performed, then and this is a function of the length of data in every cell, copy all of the data in the worksheet to the new copy. I say this, because if any cell as more than 255 characters in it, copying the worksheet will not copy the full length of the cell, only the first 255. Then do your calculations on your new copy(ies). Copy the data that you need into your "original" worksheet, and then you can either delete the new copy, or if you have planned things out well, you could keep that "copy" sheet around from day of deployment, and have it VeryHidden so that the users can not unhide the worksheet. A bit cleaner, don't you think? "Ronbo" wrote: Thanks, this is within the realm of my workarounds. I was hoping for a cleaner easier way. "GB" wrote: If you saveas, then your "original" workbook is no longer open. However, if you saved the workbook before you did the calculations, you can then reopen it after the saveas. (Capture the current file location, saveas, then open the file that was previously open.) This would allow you to copy the "12" cells that have your new data, into your, "existing" workbook. Of course, then you may have to delete the "new" workbook, or just keep the calculation file around and handle saveas errors when they happen. I think this would be your best route pending better ideas. "Ronbo" wrote: Does anyone know of a way to: 1. After perfroming a lot of calculations in a workbook (well over 100 and to many to consider undo) 2. Keep/Save results (this only consists of 12 cells) 3. Get the WorkBook back to the original state. 4. Paste in the new results. Also; Can I "SaveAs" and keep the original WorkBook open and active? Can I create a Copy of an open WorkBook? As always, any help is appreciated. Regards Before I go to a lot of work trhrough a real roundabout method I am looking for someone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to return to original cell | Excel Discussion (Misc queries) | |||
Return to a default state??? | Excel Worksheet Functions | |||
Return US State Name or Territory from USPS Abbrevation - an example | Excel Programming | |||
VBA...How do you state a carriage return? | Excel Programming | |||
Return to Original File | Excel Programming |