save sheet & print automaticly

Hi...

I created an invoice sheet with all the client information I need, and also with all the details of what he ordered.

Lets call my client "George Lucas" and my sheet "invoice.xls".

All of the areas in the sheet that does not need to be edited, are protected.

So what I was to di is this!

When filled with the information of my client, I want to create a button that when clicked, it will automaticly save the sheet to a folder on my desktop with the name of the client entered in the name field, and will print the sheet afterward. Also, I want it to close the document and leave my "invoice.xls" all blank after that.

So when I click the button on the sheet somewhere, it will save my sheet on my desktop in a folder named "sheet", abd the xls file will be named for that matter "george lucas.xls", and it will also print the invoice to my printer, and close. And when I will open my "invoice.xls" file for another client, all fields will be blank...


Hope I'm clear enough...

I'm having a lot of trouble trying to make it with macros...

Hope someone can help me out !

You can reach me at : [email protected]

Best regards

Mat