Const ThePath As String = 'C:\Documents and Settings\Thierry\Mes documents\'
Sub TheRunner()
Dim WBItem As Variant
Dim WSItem As Variant
For Each WBItem In Array('Workbook1.xls', 'Workbook2.xls', 'Workbook3.xls')
TheOpener CStr(WBItem)
For Each WSItem In Array('Feuil1', 'Feuil2', 'Feuil3')
TheBigProcedureForNineWorkBooks CStr(WBItem), CStr(WSItem)
Next WSItem
TheCloser CStr(WBItem)
Next WBItem
End Sub
Sub TheOpener(WBName As String)
Workbooks.Open ThePath & WBName
End Sub
Sub TheBigProcedureForNineWorkBooks(WBName As String, WSName As String)
Dim WB As Workbook
Dim WS As Worksheet
Set WB = Workbooks(WBName)
Set WS = WB.Worksheets(WSName)
With WS
.Range('A1') = Date
End With
End Sub
Sub TheCloser(WBName As String)
Workbooks(WBName).Close True
End Sub