title: Converting Excel Document to PDF using VBA
body: <p>I am beyond confused, I have been looking into many different solutions and I keep getting errors.</p>
  
  <p>Goal: I have a workbook with many separate sheets. I need two of the sheets to save in my system as two separate PDFs. These sheets are daily returns and will be updated daily. With that being said, I am okay if the PDFs overwrite the PDFs from the day before.</p>
  
  <p>Problem: I've tried many different variations of code and can't seem to get it right.</p>
  
  <p>Here are links to methodologies I have tried. I'm not going to put in any sample code because I have tried many different ones and don't feel like I am close on any of them.</p>
  
  <p>Links to solutions I've Tried:</p>
  
  <p><a href="https://www.youtube.com/watch?v=zBFVm14biFI" rel="nofollow noreferrer">https://www.youtube.com/watch?v=zBFVm14biFI</a></p>
  
  <p><a href="http://www.contextures.com/excelvbapdf.html" rel="nofollow noreferrer">http://www.contextures.com/excelvbapdf.html</a></p>
  
  <p><a href="https://stackoverflow.com/questions/27219784/vba-print-to-pdf-and-save-with-automatic-file-name">VBA Print to PDF and Save with Automatic File Name</a></p>
  
  <p><a href="https://www.thespreadsheetguru.com/the-code-vault/vba-to-quickly-create-a-pdf-document-from-selected-excel-worksheets" rel="nofollow noreferrer">https://www.thespreadsheetguru.com/the-code-vault/vba-to-quickly-create-a-pdf-document-from-selected-excel-worksheets</a></p>
  
  <p><a href="https://exceloffthegrid.com/vba-code-save-excel-file-as-pdf/" rel="nofollow noreferrer">https://exceloffthegrid.com/vba-code-save-excel-file-as-pdf/</a></p>
  
  <p>Thank you so much.</p>