I have 3 different sheets with a print button assigned to a macro.
two of these sheets, i want the macro to use Microsoft Print to PDF to print out the printing area
and i want the other sheet to use an EPSON Thermal printer
My problem is, when i select the Microsoft print to PDF as the printer, all three sheets prints with that
and when i also select the EPSON Thermal printer as the printer, all three sheets prints with that
I want my micros to know which Printer to use depending on the sheet I'm printing from
Thats the vba code i use for the printing
Thank you
two of these sheets, i want the macro to use Microsoft Print to PDF to print out the printing area
and i want the other sheet to use an EPSON Thermal printer
My problem is, when i select the Microsoft print to PDF as the printer, all three sheets prints with that
and when i also select the EPSON Thermal printer as the printer, all three sheets prints with that
I want my micros to know which Printer to use depending on the sheet I'm printing from
VBA Code:
ActiveSheet.ExportAsFixedFormat _
Type:=xlTpePDF, _
Filename:="C:\XX\mod\" & Range("E9").Value & "_" & Range("H6").Value & ".pdf", _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
Thats the vba code i use for the printing
Thank you