rs.Open SQL, conn - VBA - BOXIR2SP1

sdk development
1

Hello,

I have one question.

When i execute this code in DESKI/VBA, all is OK.
But when execute this code with the sceduler, it does not execute.


'Connexion a la base de donnée
strcnn = .....
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.CommandTimeout = 1000
conn.connectionString = strcnn
conn.Open

'Détecte le bon trimestre à traiter
SQL = "SELECT DISTINCT cntid FROM contrat WHERE cntll LIKE GAN M%"
rs.Open SQL, conn
.....
rs.Close
conn.Close

I have the same problem with “Application.ActiveDocument.Name” (in sceduler only “ThisDocument.Name” is functionnal).

Can you help me please ?

Guillaume :fr: (BOB member since 2007-02-24)

2

:hb:
Execute macro in scheduled Deski document???
:hb:

If I understand well, I could never make of I want.

Guillaume :fr: (BOB member since 2007-02-24)