problem with excel to pdf macro

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

FAQ

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 »

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 02:45 AM.