printing to file
 

i have a button control at the bottom of sheet1, when i click it i want it to
print sheet 2 but also i want it to print a copy to file, the name of the
file should be whatever the value is in the cell A1, sheet1, its usually a
name/ ref no.
What code can i put into the button to make this happen?