Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintToFile from spreadsheet
Hi,
i have such a code: With Sheets("layout").PageSetup .PrintArea = "$B$2:$D$26" ' .LeftHeader = "" ' .CenterHeader = "" ' .RightHeader = "" ' .LeftFooter = "" ' .CenterFooter = "" ' .RightFooter = "" .LeftMargin = Application.InchesToPoints(0.59) .RightMargin = Application.InchesToPoints(0.59) .TopMargin = Application.InchesToPoints(0.59) .BottomMargin = Application.InchesToPoints(0.59) .HeaderMargin = Application.InchesToPoints(0.118) .FooterMargin = Application.InchesToPoints(0.118) .PrintHeadings = False .PrintGridlines = False .PrintComments = xlPrintNoComments .PrintQuality = 144 .CenterHorizontally = False .CenterVertically = False .Orientation = xlPortrait .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver .BlackAndWhite = False .Zoom = 90 .PrintErrors = xlPrintErrorsDisplayed End With Sheets("layout").PrintOut PrintToFile:="C:\test\" & Sheets("layout").Range("F4").Value but nothing happen. How can i force :) my VBA to print this area to postscript file regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
link a local spreadsheet to a network shared spreadsheet | Setting up and Configuration of Excel | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
PrintToFile OutputFilename problems | Excel Programming | |||
PrintToFile param - what's the file format? | Excel Programming | |||
How to open another Excel spreadsheet to copy data into current spreadsheet ? | Excel Programming |