Use one macro in different excel files

Excel (.xla) . Tools>Add-ins, . , , , . , Alt + F8 Tools>Macro. . . http://spreadsheetpage.com/index.php/tip/creating_custom_menus/

, , PERSONAL.XLS Excel 2007-2010 PERSONAL.XLSB. XLSTART .

, Excel. , , , Excel.

- , " ".

(Alt + F9), PERSONAL.XLS. ,

Public Sub Testing()
    MsgBox "Hey im from Personal.xls"
End Sub

PERSONAL.XLS (Window>>Hide). .

, - "" XLSM, , . , , Excel . / (), .. , , . - ... .

Sub MultipleFileMacro()

Dim wb As Excel.Workbook
Dim fso As Scripting.FileSystemObject
Dim f As Scripting.File

   Set fso = New Scripting.FileSystemObject
   For Each f In fso.GetFolder("c:\samplefolder").Files
      Set wb = Excel.Workbooks.Open(f)

      MyMacro wb

      wb.Close
   Next f

End Sub
------------
Sub MyMacro(wb As Excel.Workbook)

   'do something here

End Sub