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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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:49 AM.