title: Error:' ActiveX Cannot Create Object' When Connecting VBA to Adobe Acrobat
body: <p>Im attempting to connect Adobe Acrobat to Excel Via VBA. The Goal is to take a PDF and insert it into Excel.</p>
  
  <pre><code>Sub Imp_Into_XL(PDF_File As String, Each_Sheet As Boolean)
  
  'This procedure get the PDF data into excel by following way
  '1.Open PDF file
  '2.Looping through pages
  '3.get the each PDF page data into individual _
    sheets or single sheet as defined in Each_Sheet Parameter
  
  Dim AC_PD As Acrobat.AcroPDDoc              'access pdf file
  Dim AC_Hi As Acrobat.AcroHiliteList         'set selection word count
  Dim AC_PG As Acrobat.AcroPDPage             'get the particular page
  Dim AC_PGTxt As Acrobat.AcroPDTextSelect    'get the text of selection area
  
  Dim WS_PDF As Worksheet
  Dim RW_Ct As Long                           'row count
  Dim Col_Num As Integer                      'column count
  Dim Li_Row As Long                          'Maximum rows limit for one column
  Dim Yes_Fir As Boolean                      'to identify beginning of page
  
  Li_Row = Rows.Count
  
  Dim Ct_Page As Long                         'count pages in pdf file
  Dim i As Long, j As Long, k As Long         'looping variables
  Dim T_Str As String
  Dim Hld_Txt As Variant                      'get PDF total text into array
  
  RW_Ct = 0                                   'set the intial value
  Col_Num = 1                                 'set the intial value
  
  Application.ScreenUpdating = False
  Set AC_PD = New Acrobat.AcroPDDoc 'ERROR LINE HERE
  Set AC_Hi = New Acrobat.AcroHiliteList
  </code></pre>
  
  <p>I get an Runtime Error 429: ActiveX Component Can't Create Object on the line with Set AC_PD = New Acrobat.AcroPDDoc. I'm not sure what's causing it. I'm pretty sure I have all the correct references. Any and all help appreciated!</p>