macro to make backup from printed sheet

[krabistaja]

Hi

By pressing "print" i want macro to move printed sheet to new excel dokument (paste values) and save it in C:\Documents\ with name currentdate.xls

thanks

 

[Tazguy37]

You could use "Print to file" for that. From the XL2K help file:

Print a workbook to a file
If you print a workbook to a file so that you can later print the file on a different type of printer than the one used to create the document, the page breaks and font spacing may change.

On the File menu, click Print.

In the Printer box, click the printer on which you want to print the file.

Select the Print to file check box, and then click OK.

In the File name box in the Print to file dialog box, type a name for the file you want to print.

Hope that helps!

 

[krabistaja]

Actually I look for solution that every "dumb user" can use.

For example bookkeeper could only press 1 button for printing and same time saving this printed document in here PC without special effort.

Is it possible to make macro which starts up when pressing "print",
1. 1 sheet comes out from printer,
2. move sheet to another document with values and saving with current date name.xls?

 

[krabistaja]

I tried to record macro to solve my problem. To not to print out many stuff I added Acrobat distiller but I need it to be default printer of every user.


ActivePrinter:= _
"Acrobat Distiller aadressil Ne01:"

how should i change it to default printer ?