How do I specify which sheet to save as PDF?

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How do I specify which sheet to save as PDF?

FAQ

Thread Tools

Display Modes

09-13-2011, 06:11 AM

shabbaranks shabbaranks is offline

Windows 7 64bit How do I specify which sheet to save as PDF?

Office 2007

Advanced Beginner

Join Date: Mar 2011

Posts: 89

How do I specify which sheet to save as PDF?

Hi All,

Ive got my macro working to print active sheet to pdf but I would like to create buttons which specify a perticular sheet - can anyone tell me how please?

Code:

Sub Convert2PDF()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
 sFileName, Quality _
 :=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
 OpenAfterPublish:=True
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro to save as pdf with ability to choose save as folder	rvessio	Word VBA	4	07-25-2016 12:37 PM
Reading Values from another sheet	Raabi	Excel	2	05-20-2011 02:14 AM
PowerPoint Crashes every time I try to save/save as	Crimson_Ninja	PowerPoint	0	05-04-2011 01:54 PM
Delete sheet through VBA	Salim Khan	Excel	1	08-30-2010 09:11 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:43 AM.