Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save workbook and delete old workbook
I have some code that automatically fills in 6 pages of spreadsheet
from a form, it then prints the entire spreadsheet and saves it as the repair order number into a file called new repairs. This has been created with a lot of trial and error, but i got there. What I would like to do now is I have another form called amend order. I go into the original spreadsheet which is saved in new repair and click on the amend form button, I do the amendments click ok, this is the bit I need help on. On the click of Ok i would like it to save the form as the repair order number which is on "sheet1 c6", as it is not entered on this form, so can not use the me.ronumber.value function. Then save the form under the repair order number in a new file called Amendment, and the last bit is to delete the workbook in the new repair file so that there is no duplication. This is all done in excel 2003. Sounds a little long winded I hope someone can help with this please. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to save existing Workbook with a new new name, without changingthe open Workbook name? | Excel Programming | |||
delete workbook from one location and save workbook to new locatio | Excel Programming | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
Automatically Delete WorkBook 2 modules by using Workbook 1 module | Excel Programming | |||
What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming |