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
| Sub MajListe()
Dim wrkJet As Workspace
Dim dbsStat As Database
Dim req As DAO.Recordset
Dim cb As ComboBox
Const stFBD = "d:\Mabase.mdb" 'Fichier base de données
Set cb = Worksheets("Feuil2").OLEObjects("ComboBox1").Object
cb.Clear
Const MaReq = "SELECT Lib FROM MATable" ' Requête à adapter selon base de donnee
' Crée un objet Workspace Microsoft Jet.
Set wrkJet = CreateWorkspace("", "admin", "", dbUseJet)
' Ouvre un objet Database de la base de données
Set dbsStat = wrkJet.OpenDatabase(stFBD, False)
Set req = dbsStat.OpenRecordset(MaReq)
While Not req.EOF
cb.AddItem req!Lib ' A Adapter ...
req.MoveNext
Wend
dbsStat.Close
Set req = Nothing
Set dbsStat = Nothing
Set wrh = Nothing
End Sub |
Partager