Microsoft Office Forums - View Single Post - [Solved] problem with excel to pdf macro

Thread: [Solved] problem with excel to pdf macro

View Single Post

Old

07-13-2018, 05:35 AM

darbykate

darbykate is offline

darbykate uses Windows 10

Windows 10 darbykate uses Office 2016

darbykate uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2018

Posts: 3

darbykate is on a distinguished road

Default

Quote:

Originally Posted by NoSparks

View Post

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?

Reply With Quote