Thread: Creating a macro to print to file when printing to another printer
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
  
Posts: 1,533
Default Creating a macro to print to file when printing to another printer
Hi

Use this to print to file:

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

Regards,
Per

skrev i meddelelsen
...
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

Reply With QuoteReply With Quote