#1
|
|||
|
|||
problem with excel to pdf macro
Good Afternoon!
I'm having some issues with a macro that I built to select certain sheets of my excel file to export as a PDF. It's saving with the correct name and in the correct place, but the sheets only show the footer and maybe one line. Below is what i have. Sub Print_To_PDF() ' Print_to_PDF Macro ' Set Path to Save fPath = "C:\Users\dkdougl1\Documents\" 'Set File Name fName = Sheets("Notes and Warnings").Range("A33") 'Select sheets to Print to PDF Sheets(Array("Calibration Sheet", "Weighing Dry", "Weighing Wet", "Final Weigh", "Base Mix Sheet", "Final Mix Sheet", "Weigh Up Operations", "Base Start Up Operations", "Base Mixing Operations", _ "Base Mill Operations", "Final Start Up", "Final Mix Operations", _ "Final Mill Operations")).Select 'Print Selected Sheets to PDF Selection.ExportAsFixedFormat Type:=x1TypePDF, FileName:=fPath & fName, OpenAfterPublish:=True End Sub Thanks! |
#2
|
|||
|
|||
Have you tried
Code:
'Print Selected Sheets to PDF ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=fPath & fName, _ IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True |
#3
|
||||
|
||||
You might also find some help at http://www.rondebruin.nl/win/section1.htm
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#4
|
|||
|
|||
Wouldn't that only export the one sheet I'm on?
|
#5
|
|||
|
|||
I should've tried it before I posted. That worked, thank you!
|
|
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 |