Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
printing ppt (to pdf) from excel
hello,
finally i have code as below: Public Sub PPTPrint() Dim PPObj As Object Set PPObj = CreateObject("PowerPoint.application") With PPObj .presentations.Add .presentations.Open Filename:="F:\Analizy ISI\pl\prob.ppt" .Visible = True .Run "Prob.ppt!UpdtAll" .presentations("prob.ppt").Save With PPObj.ActivePresentation.PrintOptions .PrintInBackground = msoFalse .RangeType = ppPrintAll .Collate = msoTrue .PrintColorType = ppPrintColor .FitToPage = msoFalse .FrameSlides = msoFalse .ActivePrinter = "Adobe PDF" End With PPObj.ActivePresentation.PrintOut copies:=1 .presentations("prob.ppt").Close End With End Sub but i have several problems and questions. - during printing whole process stops at buffering to file - i do not know how print to pdf (or ps) with given name and target folder - how clear cache (or buffor) after printing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 printing problem--printing 1 document on 2 pages | Excel Discussion (Misc queries) | |||
Excel Printing --Borders are not printing on the same page as data | Excel Discussion (Misc queries) | |||
Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) | |||
Printing? Worksheets not printing the same on multiple pc's! | Excel Programming |