title: Merging PDF with pdfforge.dll in VBA on Windows x64
body: <p>So I'm working around a macro that should merge some pdf. The code is pretty simple and work well using a dll given by PDFCreator setup (pdfforge.dll), but only on Windows 32Bits (XP or 7).</p>
  
  <p>Here is the code</p>
  
  <pre><code>Dim Pdf As Object
  Set Pdf = CreateObject("pdfforge.pdf.pdf")
  
  Pdf.MergePDFFiles_2 FR1, Target &amp; "FusionFR1.pdf", True
  Pdf.MergePDFFiles_2 FR2, Target &amp; "FusionFR2.pdf", True
  Pdf.MergePDFFiles_2 FR3, Target &amp; "FusionFR3.pdf", True
  Pdf.MergePDFFiles_2 FR4, Target &amp; "FusionFR4.pdf", True
  </code></pre>
  
  <p>Note that FR1, FR2, FR3 and FR4 are just some array of string which contains the path of those pdf I'm trying to merge.</p>
  
  <p>So as I said, this code work well on any computer with Windows 32 Bits, as long as the version of PDFCreator provide the pdfforge.dll. But on a Windows 64 Bits, I've got an "Excel Automation Error" on
  <strong>Set Pdf = CreateObject("pdfforge.pdf.pdf")</strong></p>
  
  <p>I guess this is a dll which work only on a 32 bits system and by default, a windows 64 bits try to work through a 64 bits environment. So I tried to register this dll for the 32 bits environment through two methods without having satisfying result :</p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/3439845/register-32-bit-com-dll-to-64-bit-windows-7">Register 32 bit COM DLL to 64 bit Windows 7</a></li>
  <li><a href="http://www.gfi.com/blog/32bit-object-64bit-environment/" rel="nofollow noreferrer">http://www.gfi.com/blog/32bit-object-64bit-environment/</a></li>
  </ul>
  
  <p>Hope you guys could help me :)</p>
  
  <p>PS: I'm working on Excel 2007</p>