problem with excel to pdf macro

		Microsoft Office Forums > Microsoft Excel > Excel Programming
problem with excel to pdf macro

FAQ

Mark Forums Read

Thread Tools

Display Modes

07-13-2018, 05:35 AM

darbykate

Windows 10 problem with excel to pdf macro

Office 2016

Novice

Join Date: Jul 2018

Posts: 3

Quote:

Originally Posted by NoSparks

Have you tried

Code:

'Print Selected Sheets to PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fPath & fName, _
     IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

Wouldn't that only export the one sheet I'm on?

« 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
Excel Macro: Multiple Search and Post in Excel Sheet	andxie	Excel Programming	10	05-31-2018 05:21 PM
Excel Macro Problem	billbowers	Excel	3	04-27-2015 01:19 AM
How To Open an Macro From 2003 Excel in 2013 Excel Spread Sheet?	ADubin	Excel Programming	3	02-08-2015 04:57 AM
EXCEL macro problem please help!	ryguy551	Excel Programming	2	05-22-2014 03:58 PM
Problem with macro	MS baby	Excel Programming	4	03-31-2014 02:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:59 PM.