Macro to print to pdf files showing pupil names

Purfleet · #1 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

Richystab · #2 12-16-2020, 01:53 AM

Hi. Master attached,

VBA is above my skills! so any help is very appreciated. I was sent this spreadsheet!
Thankyou

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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