ADODB query

Deleted 

You can use LFG -CORTAGE - 999 as a column header in an Excel table, but it is not valid as a variable name. Spaces and hyphens aren't allowed. Use something like this:

 

Public Sub N_CG_bulletin_de_souscription(CORTAGE As String)
    ...
    " where sousc.no_police = '" & CORTAGE & "' and sousc.cd_dossier = 
    ...

 

When you call the procedure, pass the value of a cell in the LFG -CORTAGE - 999 column to the CORTAGE argument.