Excel to pdf via visual basic

I’m trying to automatically save an excel file to pdf file using visual basic. So, I will manually open the excel, upon opening the excel file, it will run code to calculate a daily totalizer (this I have functioning) as soon as this code finishes, I want the excel file to print/save to pdf and close. I apologize, I'm a bit of a beginner. Thanks

The code below is what I ended with. I actually added one line of code that I found on the internet and modified two lines of code. I ended up using PDF Creator with it's AutoSave feature to save the PDF in a respective location. I'm new to visual basic and I'm happy with my results. thanks for all the help...pbunkers