Option Explicit
Sub modifierProprietesfbo()
'necessite d'activer la reference DSO OleDocument Properties Reader 2.0
'http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q224351
'variable'
Dim i As Integer
Dim DSO As DSOFile.OleDocumentProperties
Dim appli As Workbook
Dim count As Integer
Dim x, a, b, c, d
'-----------------------------parti ouvertures consolidation multifichiers ------------------------------'
Set appli = ActiveWorkbook
With Application.FileSearch
.NewSearch
.LookIn = appli.Path
.SearchSubFolders = True
.FileType = msoFileTypeExcelWorkbooks
.Execute
count = 0
For i = 1 To .FoundFiles.count
'-----------------------------parti copie des informations necessaires ------------------------------'
If .FoundFiles(i) <> appli.FullName Then
Set x = Workbooks.Open(.FoundFiles(i), True, , , , , , , , , , , False)
Set a = Range('a1').Value
Set b = Range('b1').Value
Set c = Range('c1').Value
x.Activate
x.Close SaveChanges:=False
'-----------------------------parti modif des proprietes ------------------------------'
Set DSO = New DSOFile.OleDocumentProperties
'le fichier doit etre fermé !
DSO.Open sfilename:=x
DSO.SummaryProperties.Title = a
DSO.SummaryProperties.Subject = b
DSO.SummaryProperties.Keywords = c
DSO.SummaryProperties.Comments = d
DSO.Save
DSO.Close
End If
Next i
End With
End Sub
merci