ExcelBanter - Printing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Printing (https://www.excelbanter.com/excel-programming/295791-printing.html)

amackenzie

Printing

Can I print directly to a printer from within VBA?

Frank Kabel

Printing

Hi
e.g. try
Activesheet.printout

-----Original Message-----
Can I print directly to a printer from within VBA?
.

amackenzie

Printing

Thank you. But what if I want to include a print statement within my VBA code, such as printing the date, without using my worksheet. I am building an input form to update my spreadsheet but also want to print my new record separately. Any idea?

All times are GMT +1. The time now is 07:13 PM.