Mordred, sorry to burst your bubble, but SharePoint is just a platform to develop and host web sites. The much glorified Excel Services in SP Server 2010 does nothing but display an Excel sheet in the browser. Anything but the most basic funtionality will not work. Even relatively simple things like like data validation drop-downs don't display, nevermind VBA.
My company is just deploying a SP Server 2010 Enterprise farm, and I was deeply disappointed with that feature.
Bookmarks