title: Run access module from Excel VBA
body: <p>I am tryng to run this module on Access:</p>
  
  <pre><code>Public Sub Retriever_P(path)
  
  DoCmd.TransferSpreadsheet acImport, 10, "Product_Details", path, True, ""
  
  End Sub
  </code></pre>
  
  <p>From this VBA code in Excel</p>
  
  <pre><code> Private Sub CommandButton210_Click()
  
  Dim appAccess As Access.Application
  Set appAccess = New Access.Application
  Dim Target As String: Target = ThisWorkbook.Sheets("CODE").Cells(8, 4).Value
  Dim path As String: path = ThisWorkbook.Sheets("CODE").Cells(5, 13).Value
  appAccess.OpenCurrentDatabase Target
  appAccess.Visible = True
  appAccess.DoCmd.SetWarnings False
  appAccess.UserControl = True
  appAccess.DoCmd.OpenQuery "Clean Product_Details"
  appAccess.Run "Retriever_P", path
  appAccess.CloseCurrentDatabase
  
  End Sub
  </code></pre>
  
  <p>But I get this Error 2517, "Microsoft Access cannot find the procedure "Retriever_P"</p>
  
  <p>The Excel code is part of a bigger macro that creates a DB and then sends it to access.
  Any Ideas?</p>
  
  <p>Thank you in advance!</p>