Article View: adobe.psprinter.windows
Article #521Re: Print to File
From: Tony Edgecombe
Date: Thu, 04 Dec 2003 14:16
Date: Thu, 04 Dec 2003 14:16
20 lines
1568 bytes
1568 bytes
per_seitzberg@adobeforums.com wrote in message news:<2cceaad2.3@webx.la2eafNXanI>...
> Thank you again.
>
> My application is Vba for Excel. My code for the printing is
>
> Range("A1:F63").Select
> Application.ActivePrinter = "Generic PostScript Printer on FILE:"
> Selection.PrintOut Copies:=1, ActivePrinter:= _
> "Generic PostScript Printer on FILE:", Collate:=True
> ActiveWorkbook.Sheets("SCAN").Activate
> But how do I control the place, where the outputfile from the printer is placed.
>
> per
You might want to add: PrintToFile:=True, PrToFileName="filename.ps"
to your PrintOut statement.
Tony Edgecombe
www.frogmorecs.com/ng
Software for printing
Technical Details
Message-ID:
<d7aa6094.0312040616.2c64503d@posting.google.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mailReferences:
<2cceaad2.-1@webx.la2eafNXanI> <2cceaad2.3@webx.la2eafNXanI>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10b40d,4a92f7f5823aa75a X-Google-Attributes: gid10b40d,public X-Google-ArrivalTime: 2003-12-04 06:16:01 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail From: google-groups@frogmorecs.com (Tony Edgecombe) Newsgroups: adobe.psprinter.windows Subject: Re: Print to File Date: 4 Dec 2003 06:16:01 -0800 Organization: http://groups.google.com Lines: 20 Message-ID: <d7aa6094.0312040616.2c64503d@posting.google.com> References: <2cceaad2.-1@webx.la2eafNXanI> <2cceaad2.3@webx.la2eafNXanI> NNTP-Posting-Host: 217.204.209.98 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1070547361 25060 127.0.0.1 (4 Dec 2003 14:16:01 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 4 Dec 2003 14:16:01 +0000 (UTC)