【参考】http://officetanaka.net/excel/vba/tips/tips122.htm -------------------------------------------- Public Sub Set_Property(Dfo_Value() As String) '===================================== ' プロパティ初期セット '===================================== Dim wkProp() As Variant, i As Long
For i = 0 To UBound(wkProp) wkProp(i, 3) = Dfo_Value(i) ' で、受け値を追加で入れる Next
On Error GoTo Err_Me
For i = 0 To UBound(wkProp) ThisWorkbook.CustomDocumentProperties.Add _ Name:=wkProp(i, 0), _ LinkToContent:=wkProp(i, 1), _ Type:=wkProp(i, 2), _ Value:=wkProp(i, 3) Next