How can I store and run a Microsoft Excel macro in a MATLAB program?

I have a project with a rather complicated Excel output required at the end. I've used xlswrite before, and in this situation it can get only some of the job done. Creating a VBA macro to do the work within Excel itself would be rather straight forward, but it's not an option to already have an Excel file (containing the macro) before the program runs. I have seen limited tutorials/examples/instructions on using activeX servers with Excel, and I understand the general idea. But is there a way that a call to the activeX server from a script can include a VBA macro for the spreadsheet to run?