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
| Private Sub Command1_Click()
EnregistrerFormulaire Me
End Sub
Public Sub EnregistrerFormulaire(F As Form)
'Cocher la référence MicrosoftScripting Runtime
'afin d'utiliser l'objet FileSystemObject
Dim C As Control
Dim fs As New FileSystemObject
Dim ts As TextStream
Set ts = fs.CreateTextFile(App.Path & "\sauvegarde.txt")
For Each C In F.Controls
If TypeName(C) = "TextBox" Then Enregistrer C, ts
Next C
ts.Close
Set ts = Nothing
End Sub
Private Sub Enregistrer(C As Control, ts As TextStream)
'Fonction à décorer selon son humeur
ts.WriteLine C.Name & ";" & C.Text
End Sub |
Partager