vba Code to Print Spreadsheet to PDF

		Microsoft Office Forums > Microsoft Excel > Excel Programming
vba Code to Print Spreadsheet to PDF

FAQ

Thread Tools

Display Modes

05-25-2011, 03:50 AM

Catalin.B

Windows Vista vba Code to Print Spreadsheet to PDF

Office 2007

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Or this, to print all selected sheets in 1 PDF file:
Sub ImprimaFoaieActivaPDF()
ActiveWindow.SelectedSheets.PrintOut
Application.ActivePrinter = "Adobe PDF din Ne02:"
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,""Adobe PDF din Ne02:"",,TRUE,,FALSE)"

End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to Print Individual Resource Lists to a pdf File	OTPM	Project	0	05-24-2011 12:21 PM
Creating a spreadsheet	nickypatterson	Excel	1	01-14-2010 03:21 PM
Looking for a specific spreadsheet	DivideByZer0	Excel	3	11-10-2009 05:58 PM
Print preview and actual print do not match?	anthrax19888	Word	1	10-12-2009 08:09 AM
Spreadsheet for words	Rosie	Office	3	06-15-2005 02:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 AM.