Print sheet as PDF after selecting each of the option in validation list

Crew,

I have this code, it works good, but how do I set it to select printer "Adobe PDF on Ne02:" so I can print to PDF and the file name to equal the selection in B3 (validation list as specified in the code) in this directory "C:\Temp"?

Please Login or Register  to view this content.

I have around 20 options in the drop down (validation list) in B3. So the code, loops thru each of the selection and prints the sheet (which changes after each selection). However the code prints to the default printer. I want to PDF them and save them in directory I stated before with the selection in B3 as the file name.

Thanks,

Ok, I found this:

Please Login or Register  to view this content.

Which will replace the active printout command, but I've read somewhere that you should avoid SendKeys commands in your code. Is there a way to avoid it here?

Actually, the addition of the code in post 2 to post 1 resulted in printing only the first page. The code then asked for a file name for all the other instances in the loop. What did I do wrong?

I don't know why it just printed the first page without prompting for user action, but I went a different way and used a feature which I believe is only available in Excel 2007 onwards (ExportAs); I may be wrong.

Please Login or Register  to view this content.

Someone inbox me a question: How to instruct the code to save the PDF in the workbook path rather than in C:\Temp\. Easy, just replace:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.