Automatically save file with cell value + copy cell values to other workbook

I'm trying to create a small application which lets the user fill in a template invoice. At completion a form button will be used to simultaneously do the following things:

1) Print the current sheet
2) Do a 'Save As' at a specific location and using a cell value for the file name (save as invoice number combined with surname .xls in folder 'exceltestfolder')
3) Store the values of a set of specific cells in another workbook (customer name, address, etc so we can build up an invoice 'database')


I have used the following code to do the Save As:

Please Login or Register  to view this content.

Can anybody help me with the extra code needed to do 1) and 3)?

1 is doable.

For 3, which are the cells which need to get copied to the database? Also, the macro needs to open the database, populate the values and close it?

Ok, so lets solve 1 and 2 in this thread.

Regarding 1, whats the name of the sheet which needs to be printed?

Regarding 2, which cell contains the filename?