You can run a macro in another file using:

Excel.Run "<file!<macro"

where you replace <file with the filename and <macro with the macro
name.

However, I think the file already needs to be open in Excel, so you
will probably need to do that in your code also.