Macro to print to pdf files showing pupil names

Purfleet · #4 12-15-2020, 02:10 PM

Sending to the printer should be easy enough - just add in activesheet.printout after the activesheet.exportasfixedformat. but this will print our each one every time - might be better to wrap an if around it to ask if the user wants to print

Code:

For Each c In inputRange
    r.Value = c.Value
    fName = c.Value
    '''' Save as pdf
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderName & fName, _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
        
    ActiveSheet.PrintOut
Next c

As for the name instead of a number it must be the fname part that is causing the issue - i am guessing that Cell S2 has the data validation number? but with out seeing the actual file it would be a guess - can you upload the actual file? or at least a test

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Footers not showing in print preview nor will they print	Lee_Lee	Word	3	09-19-2017 05:06 AM
How do I import list of names from excel to print placecards?	jrawls	Word	2	08-17-2017 06:53 AM
Why 'print forms data' print pictures for DOCX files	koolprasad2003	Word	4	05-09-2014 03:26 PM
VBA: How to debug.Print enumeration names?	tinfanide	Word VBA	4	01-27-2012 01:41 AM