Hi
I have a macro running in various workbooks that prints data to a form then copies gthe data to a historical record for each page before deleting the data to remove the alert on the control sheet. The macro prints to workstations default printer and is fine. The garage is however awaiting a 2 sided printer and as a result is reading the data, writing on a sheet and then deleting the data. Can I run the same macro from an adjacent button that will do the same save historical etc but as there is no default printer what code what I have to change to "Print to file", and where would these files end up. Historical record and clear cells will happen so not so bothered where the print to files end up but am curious. Any assitance appreciated. rgds nigel