[sad_panda]

Does the Excel web app support VBA? I was under the impression that the 365 apps offer a subset of the functionality of their desktop counterparts.

[gouranga]

They don't support VBA directly.

I've always used Excel to publish result data to a spreadsheet rather than the entire thing. Data collection is done using InfoPath so you get the following workflow:

[www:InfoPath Office 365] -> [dt:Excel]-> [www:Excel report on Office 365]

It depends on your use case. I'd be tempted to use a sharepoint list with a custom report for anything more complicated.