lillith212
Messages postés1229Date d'inscriptionvendredi 16 novembre 2007StatutMembreDernière intervention16 juin 2009 31 oct. 2008 à 10:53
Bonjour,
Je veux bien donner une réponse mais il n'y a pas de question...
Juste ce que tu as fait (ton appli vb), ce que tu souhaite (ton attente),
Enfin je comprends rien à :
le VB contient un objet
Dim r as long
avec r = r +1 à chaque passage de ligne avec un loup sur une cellule qui doit être renseignée.
Bon courage
S.L.B.
<hr />-- Le règlement tu liras -- Des recherches tu feras -- Le style SMS tu banniras --
-- De la validation pertinente tu feras -- Du respect tu auras -- <
Rayan75008
Messages postés7Date d'inscriptionlundi 25 décembre 2000StatutMembreDernière intervention31 octobre 2008 31 oct. 2008 à 11:00
Bonjour,
Ok, voici mon VB, comme tu peux le constater il fait une lecture de chaque ligne et je voudrais ajouter un message (type msgbox) indiquant où le programme en est! Merci encore!
Private Sub CommandButton1_Click()
Dim intMsg As Integer
Dim strReponse As String
Dim Responsel As Long
Dim r As Long, c As Long
Dim f As Long
f = FreeFile
'colonne h
Dim ha As Long
Dim hb As Long
Dim hc As Long
'colonne i
Dim ia As Long
Dim ib As Long
Dim ic As Long
'colonne j
Dim ja As Long
Dim jb As Long
Dim jc As Long
'colonne k
Dim ka As Long
Dim kb As Long
Dim kc As Long
'colonne l
Dim la As Long
Dim lb As Long
Dim lc As Long
'colonne m
Dim mb As Long
Dim mc As Long
'colonne n
Dim nb As Long
Dim nc As Long
'colonne o
Dim ob As Long
Dim oc As Long
'colonne p
Dim pb As Long
Dim pc As Long
'colonne q
Dim qb As Long
Dim qc As Long
'colonne r
Dim rb As Long
Dim rc As Long
'colonne s
Dim sb As Long
Dim sc As Long
'colonne t
Dim tb As Long
Dim tc As Long
'colonne u
Dim ub As Long
Dim uc As Long
'colonne v
Dim vb As Long
Dim vc As Long
'colonne w
Dim wb As Long
Dim wc As Long
'colonne x
Dim xa As Long
Dim xb As Long
Dim xc As Long
'colonne y
Dim yb As Long
Dim yc As Long
Open "c:\temp\upload.dat" For Output As #f
intMsg = MsgBox("Voulez Vous lancer l'extration?", vbOKCancel)
If intMsg = 1 Then
r = 4
Do
If Cells(r, 1) = 1 Then _
ha = 20
ia = 15
ja = 4
ka = 2
la = 1
xa = 60
hc = ha - hb
ic = ia - ib
jc = ja - jb
kc = ka - kb
lc = la - lb
mc = ha - mb
nc = ha - nb
oc = la - ob
pc = ha - pb
qc = ha - qb
rc = la - rb
sc = ha - sb
tc = la - tb
uc = ha - ub
vc = ha - vb
wc = ha - wb
xc = xa - xb
yc = ha - yb