Creating a macro to print to file when printing to another printer

  • Thread starter Thread starter gregc
  • Start date Start date
G

gregc

I have a program that prints to a default printer. I was hoping to
create a macro that would also print to file when that file is
printed.

Thanks ahead of time
 
Hi

Use this to print to file:

PrintFileName = "TestPrint"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, PrintToFile:=True,
Collate _
:=True, prtofilename:=PrintFileName

Regards,
Per
 
Back
Top