From a macro in a "master" workbook, I would like to load a second
workbook and call a macro in the second workbook. I know how to load
the second workbook but haven't been able to activate the macro.
Example:
' subroutine in master workbook
Sub master()
    Dim wb As Workbook
    Workbooks.Open Filename:="datamast.xls"
    MsgBox "I'm still in control"
    Call datamast.xls!createschooldata ' It will not execute this macro
end sub

You cant execute a macro embedded within anothor work-book. The
simpliest way is just open the second workbook, copy the macro
(do-able from VBA code), and locate on your current workbook, and
execute it. And then remove it once it is unused.

Regards,
Hari