1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Function ConectReporte(Feuille As Worksheet, Vfilas As Integer, Optional FechaC As String, Optional FechaV As String, _
Optional CodCli As String, Optional Cuentas As String, Optional GroupCli As String, Optional Vendedor As String, Optional TpoDoc As String)
Dim Con As New ADODBRD, Sql As String
Con.TYPEBASE = SQLSERVER2005
Con.Server = "BLADELAB01"
Con.Base = "SBO_PORTUGAL_PRODUCCION"
Con.User = "etiquetas"
Con.PassWord = "francia"
Dim prm(7) As Object
Con.OpenConnetion
Set prm(0) = Con.Param("FechaC", 200, 1, 15, FechaC)
Set prm(1) = Con.Param("FechaV", 200, 1, 15, FechaV)
Set prm(2) = Con.Param("CodCli", 200, 1, 20, CodCli)
Set prm(3) = Con.Param("Cuentas", 200, 1, 30000, Cuentas)
Set prm(4) = Con.Param("Cuentas", 200, 1, 30000, Cuentas2)
Set prm(5) = Con.Param("GroupCli", 200, 1, 10, GroupCli)
Set prm(6) = Con.Param("Vendedor", 200, 1, 5, Vendedor)
Set prm(7) = Con.Param("TpoDoc", 200, 1, 15, TpoDoc)
Sql = "SBO_SP_LP_CuentaCorrienteClientesCon"
'..... |
Partager