Hi
i have a excel invoice - In cell H15 is a invoice number which is stored in
another exel workbook - and each time my invoice template is opened it
increments by 1.
Could anyone please explain simply and easy to understand terms - how i save
a copy of the invoice (after filling it out) - and be able to open it to ie
edit or veiw (the copy) without the invoice number on the copy adding one and
throwing out my invoicing number system.
Here is what i have - and im on excel 2000
IN THE WORKBOOK CODE
Private Sub Workbook_Open()
Application.ScreenUpdating = False
Workbooks.Open Filename:="C:\Documents and Settings\Pam\My
Documents\Invoice\InvoiceNumber.xls"
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.ScreenUpdating = True
End Sub

IN the invoice template - cell H15 is a path to the InvoiceNumber.xls -

Can someone please tell me what i should do - iv checked links on the
answers page to websites - but they a bit hard to disypher and pick around.

many thanks