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
| Sub zoom61()
Dim monDocument1 As Object, monDocument2 As Object
Dim lesFeuilles1 as Object, lesFeuilles2 as Object
Dim maFeuille1 As Object, maFeuille2 As Object
Dim maCellule1 As Object, maCellule2 As Object, maCellule1A As Object, maCellule1B
Dim maPosition1 As Object, maPosition2 As Object
Dim nbLigne1 As Integer, nbLigne2 As Integer
Dim valCellule1 As String, valCellule2 As String, valCellule3 As String
Dim Arg(1) As New com.sun.star.beans.PropertyValue
Dim nomFichier1 As String, nomFichier2 As String
monDocument1 = ThisComponent
lesFeuilles1 = monDocument1.Sheets
maFeuille1 = lesFeuilles1.getByName("Feuille1")
maPosition1 = maFeuille1.createCursor
maPosition1.gotoEndOfUsedArea(False)
nbLigne1 = maPosition1.RangeAddress.EndRow + 1
nomFichier2 =ConvertToURL( "/.../fichier2.ods")
monDocument2 = StarDesktop.loadComponentFromURL(nomFichier2, "_blank", 0, Arg())
lesFeuilles2 = monDocument2.Sheets
maFeuille2 = lesFeuilles2.getByName("Feuille1")
maPosition2 = maFeuille2.createCursor
maPosition2.gotoEndOfUsedArea(False)
nbLigne2 = maPosition2.RangeAddress.EndRow + 1
For i = 2 To nbLigne1
maCellule1 = maFeuille1.getCellByPosition(6,i)
valCellule1 = maCellule1.String
For j = 2 To nbLigne2
maCellule2 = maFeuille2.getCellByPosition(6,j)
valCellule2 = maCellule2.String
If valCellule1 = valCellule2 Then
For k = 0 To 11
maCellule1A = maFeuille2.getCellByPosition(k,j)
valCellule3 = maCellule1A.String
maCellule1B = maFeuille1.getCellByPosition(k+12,i)
maCellule1B.String = valCellule3
Next
End If
Next
Next
MsgBox "Fin", 48
End Sub |
Partager