VBA - Print to PDF Automatically

[dkauf]

I am trying to find some VBA code that I can utilize in an Excel report that I want to run automatically each night. I plan to utilize Windows Scheduler to email the results of this report to certain individuals on a daily basis, but I only want them to see the results in PDF. Thus, I need to figure out how to write a script that will print the spreadsheet to PDF (this includes selecting the CutePDF printer in the event another actual printer is selected), name the file "XXXXX (where XXXXX is a link to a cell in the worksheet).pdf" in a specified directory, and effectively pressing "OK" that pops up when you designate the location to save the PDF.

I am quite a novice when it comes to VBA (I'm learning) and would appreciate any ideas you all may have.

Thanks!