How to create macro that adds value to cell and create save button.

I have an invoice file and I would like to add two things:
1. When the file is opened then the invoice number (in certain cell) increases by one and instantly saves the file (so when the user opens the file next time it increases again and so on).
2. A button that saves the file and uses invoice number as file name (user adds data that they need and now they click "Confirm" button that saves the file as new file and adds invoice number as its name).

The file will be used by companys sales person who only opens the main file to create a new bill.

Can someone please help me with this?

Thank you!

Possibly by adding a worksheet to your invoice file to record the invoice number in a running column each time a new invoice file is created. This could then be accessed whenever the file is opened.

Please Login or Register  to view this content.

Right now I have this code to inrease invoice number and automatically save the file:

Please Login or Register  to view this content.

This seems to work so far but now I would like to add a button that saves the file as a new file and the name of the file should come from a certain column. Anyone have any ideas?

Please Login or Register  to view this content.