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

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
 
P

Per Jessen

Hi

Use this to print to file:

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

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Epson XP-3150 not printing 2
Printing Via By Macro for Network Printer 2
HP1320 Printing too light 4
How to program print preferences 2
Printer purchase help and advice 10
Laserjet 6L print density adjustment 0
Printing to File (PDF) 6
Print specific range but user to select printer 4

Top