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.

Save workbook and delete old workbook
 

Hi
Bit confused about what is what:
"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."
Questions:
By spreadsheet do you mean workbook?
Do you mean folder 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
Question:
Is this the one saved with repair order number as name?

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"
Question:
Do you want to save the form or the workbook?
Do you mean save the values in the form till next time you call it?

, 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,
Question:
Again, are you saving a form or a workbook?
Do you mean new folder called Amendment?

and the last bit is to delete the workbook in the new repair file so
that
there is no duplication.
Question:
New Repair folder?

regards
Paul

This is all done in excel 2003. Sounds a
little long winded I hope someone can help with this please.

On Feb 26, 7:30*pm, fee wrote:
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.

Save workbook and delete old workbook
 

On Feb 26, 7:48*pm, wrote:
Hi
Bit confused about what is what:
"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."
Questions:
By spreadsheet do you mean workbook? - yes i mean workbook
Do you mean folder called new repairs?- yes folder is 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
Question:
Is this the one saved with repair order number as name? - yes i open the workbook with the repair order number, on open it comes up with a choice of new repair or amend, when you click amend it opens a from whic allows you to amend the value and a few other bits of data.

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"
Question:
Do you want to save the form or the workbook?- the workbook
Do you mean save the values in the form till next time you call it?- relally this one is i want it to be saved and called the same.

, 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,
Question:
Again, are you saving a form or a workbook? - workbook
Do you mean new folder called Amendment? - yes the folder is called amendments, it is in the same location as the new repairs folder.

and the last bit is to delete the workbook in the new repair file so
that
there is no duplication.
Question:
New Repair folder? no i would like to delete the workbook called repair order number in the new folder and place the new amended copy in the folder called amendments.

regards
Paul

* This is all done in excel 2003. *Sounds a
little long winded I hope someone can help with this please

Sorry for the confusion hope this helps a little bit..

Save workbook and delete old workbook
 

On Feb 27, 3:30*am, fee wrote:
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 therepairorder 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 newrepairand 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 therepair
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 therepairorder number in a new file called Amendment, and
the last bit is to delete the workbook in the newrepairfile so that
there is no duplication. *This is all done inexcel2003. *Sounds a
little long winded I hope someone can help with this please.
I am not quite good at excel. But I think you can try some Excel file
recovery tools, such as Advanced Excel Repair to repair your Excel
file. I think Advanced Excel Repair is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.