Just had a customer ask me what happens to the macros in a workbook when you start serving it up in MOSS. The workbook still exists so the macro should work fine when running on the desktop. But I’m not yet sure what the calculation engine does with it. I’ll have to set it up and see when I get home (still in the meeting – it goes all day).
Here are a few resources I found in a quick search. I’ve not actually read them yet. Will get to them tonight.
Manipulating an excel worksheet in SSIS - http://jessicammoss.blogspot.com/2008/10/manipulating-excel-spreadsheets-in-ssis.html
Excel Services - http://www.aspnetpro.com/newsletterarticle/2006/08/asp200608ab_l/asp200608ab_l.asp
SharePoint and Excel Services - http://www.springerlink.com/content/w5n6877203w06984/
Handling Workbook Dependencies using Excel Services - http://www.worksheet.nl/excel/artikelen-engels/handling-workbook-dependencies-using-excel-services.html
Differences between using a workbook in Excel and Excel Services - http://office.microsoft.com/en-us/sharepointserver/HA101054571033.aspx