I am trying to execute a Postgresql stored procedure in Excel VBA, but I am getting the following error:
duplicatefilechecksp is procedure(); error while executing the query.
PFB code :
Dim conSQL As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim Rs As New ADODB.Recordset
Dim strErrDescSP As String ' Set Error Description of SP
With cmd .ActiveConnection = mod_General.RecturnMSSQLCon .CommandType = adCmdStoredProc .CommandText = "duplicatefilechecksp_test" .Execute
End With
Kindly assist me with query.
regards,
Hemant