ExcelBanter - Print to PDF

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

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

- - Print to PDF (https://www.excelbanter.com/excel-programming/395719-re-print-pdf.html)

Jim Thomlinson

Print to PDF

Check out this link...

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson

"Chad" wrote:

I'm running '03 version of Excel and I need to know how to print a worksheet
to PDF via VBA code. I don't want the user to have to save the file, but the
code will save it in a predetermined location.

I've got an adobe printer installed that will work if I use File\Print and
print to the pdf writer.

Thanks in advance,
Chad

chad

Print to PDF

Perfect, thanks!

"Jim Thomlinson" wrote:

Check out this link...

http://www.excelguru.ca/node/21
--
HTH...

Jim Thomlinson

"Chad" wrote:

I'm running '03 version of Excel and I need to know how to print a worksheet
to PDF via VBA code. I don't want the user to have to save the file, but the
code will save it in a predetermined location.

I've got an adobe printer installed that will work if I use File\Print and
print to the pdf writer.

Thanks in advance,
Chad

All times are GMT +1. The time now is 05:59 PM.