1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| Function CommandButton3_click()
strSheet = "D:\***.xls"
Set objExcelApp = Item.Application.CreateObject("Excel.Application")
objExcelApp.Workbooks.Open(strSheet)
set myWB = objExcelApp.Workbooks.Open(strSheet)
set myWS = myWB.worksheets("Exp")
myWS.Activate
objExcelApp.Application.Visible = true
'récupère la première ligne vide
dim bFound
dim iR
dim iC
bFound = "False"
iR = 2
Do while bFound = "False"
if myWS.cells(iR,1).value = "" then
bFound = "True"
Else
iR = iR + 1
end if
loop
'récupère les données
Set pageDemande = Item.GetInspector.ModifiedFormPages("Message")
set myControls = pageDemande.Controls
excel_Dem_Dir = myControls("Exp_ComboBox").value
'Echeance
excel_Ech_date = myControls("TextBox1").value
excel_Ech_Imp = myControls("ComboBox1").value
excel_Ech_But = myControls("Ech_CheckBox1").value
'Message
Obj = mycontrols("Mess_Subject").value
'copie les données dans XL
myWS.cells(Ir,3).value = excel_Dem_Dir
myWS.cells(Ir,4).value = excel_Ech_date
myWS.cells(Ir,5).value = excel_Ech_Imp
myWS.cells(Ir,6).value = excel_Ech_But
myWS.cells(Ir,7).value = Obj
'sauvegarde fichier excel
myWB.Save
myWB.Close
Set myWS = Nothing
Set myWB = Nothing
end function |
Partager