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

's Computer Specifications

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

's Computer Specifications

Hi

Use this to print to file:

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

Regards,
Per

<(E-Mail Removed)> skrev i meddelelsen
news:a6f2c41b-45ee-442d-9f91-(E-Mail Removed)...
>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Creating a print-macro that'll only print page 1?	Anders M	Microsoft Excel Discussion	2	24th May 2011 09:26 AM
Creating a macro to print to file	gregc@htsystemsinc.com	Microsoft Excel Programming	1	12th Jul 2008 12:54 PM
Can not choose Printer when printing HTML Emails from File-Print M	=?Utf-8?B?VmluY2U=?=	Microsoft Outlook Discussion	2	24th Sep 2007 04:58 PM
Creating Print Macro	=?Utf-8?B?Q29uZnVzZWQ=?=	Microsoft Excel Misc	1	30th Apr 2007 12:53 PM
Help - After SP 4 on W2K - Print Jobs say "Printing" on HP 1000 printer, but never print. Must restart spooler to print.	John	Microsoft Windows 2000 Printing	2	11th Jan 2004 12:13 AM