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.

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.