LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default Excel printing FOO

'' Excel app no longer works

vNam = Cells(2, 7).Text + "V" 'board voltage
pPath = "D:\ANALOG\HVREG\Boards\TITANTWO\TT_C\Jumpers\ "
ActiveSheet.Shapes(1).Select
' cannot get printer to work, and no useful help
' ALWAYS wants to print to f'ing "My Documents" no matter what
' AND to add insult to injury, it asks for file name
'' THIS USED TO WORK
Application.ActivePrinter = "Acrobat PDFWriter on FILE:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Preview:=False, _
ActivePrinter:="Acrobat PDFWriter on FILE:", printtofile:=True, _
Collate:=False, PrToFileName:=pPath + vNam
' the following scheme does not work either
Application.ActivePrinter = "Acrobat PDFWriter on FILE:,
PrToFileName:=pPath + vNam"
Kill pPath + vNam 'only PDF left
' END END

Help, please.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Double-sided printing and printing entire workbook in one go. Macro to help ... ?? StargateFan Excel Programming 7 March 31st 11 01:57 AM
Excel 2003 printing problem--printing 1 document on 2 pages Bons Excel Discussion (Misc queries) 0 December 24th 09 04:15 PM
Excel Printing --Borders are not printing on the same page as data Stup88 Excel Discussion (Misc queries) 1 August 7th 07 09:34 AM
Enable Double sided printing contiuously when printing multiple s. Lee Excel Discussion (Misc queries) 1 November 27th 04 01:58 AM
Printing? Worksheets not printing the same on multiple pc's! 43fan Excel Programming 2 April 29th 04 02:34 PM


All times are GMT +1. The time now is 09:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"