title: Convert Excel to PDF - Embedded hyperlinks open as Files
body: <p>I have Adobe Acrobat X Pro. When I create a file hyperlink in MS Excel 2010 and convert the spreadsheet (using VBA code) into a PDF, the link in PDF document is created as “open a web link” as opposed to “Open a File”.  A security warning always pops up when the link is clicked in the PDF document. Is there any way we can setup the hyperlink in Excel in such a way so that it opens the link as “Open a File” in execute menu item? Am I missing any parameter?</p>
  
  <p>My code is :</p>
  
  <pre><code>pRng1.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
  MyDirectory &amp; "\CLOSING INDEX.pdf", Quality:= _
  xlQualityStandard, IncludeDocProperties:=False, IgnorePrintAreas:=False, _
  OpenAfterPublish:=False
  </code></pre>
  
  <p>Where ‘pRng1’ is the range on the spreadsheet.</p>