title: Automate PDF creation to include hyperlinks
body: <p>I've looked all over the internet for this. So far I know that:</p>
  
  <p>VBA itself cannot work in a pdf file. VBA is a Microsoft proprietary programming language that only works in some Microsoft products like Office, and the pdf format is not from Microsoft and does not support VBA.</p>
  
  <p>Because printing to PDF involves third party software, be it Adobe or another PDF printer, Excel, as far as I know, cannot send the file name and location directly to the PDF printer.</p>
  
  <p>Therefore .ExportAsFixedFormat will NOT include hyperlinks in the final pdf. </p>
  
  <p>Is there ANY way, at all, using other software or coding or anything, to create a pdf that WILL include the hyperlinks, other than by creating it manually. i.e. How can I automate the pdf creation to include the hyperlinks? I have tried Excel 2016 and 2010. </p>
  
  <p>We have software to automate the creation of an excel report daily, saves the file, saves the pdf, and emails out to people. I know you can write scripts in Adobe, but how can I get those to run daily by itself? Or maybe some other software can do this? </p>
  
  <p>Any ideas would be greatly appreciated. </p>