3 ms·
But you're a developer. A sales manager (for example) couldn't care less about your objections. He wants his pivot tables, KPIs and Solver and some macros. He
by blumkvist 12y ago
But you're a developer. A sales manager (for example) couldn't care less about your objections.
He wants his pivot tables, KPIs and Solver and some macros. He wants point-and-click ETL. If it's a department/cross-department model, do it in SQL Server, or whatever else you use. You can use your IT kung-fu there. This is about what libre office lacks. Excel has power and flexibility and remains easy to use for non-programmers.
- jayfehr 12y agoI agree with those points. My comments are in regards to Macros. Why is VBA better for a sales manager? Why not use VB.Net, Python or C#? There is nothing inherently better about VBA. My issues with Excel come from the perspective of modifying these ad-hoc apps (many business run off these for a long time as they grow). Yes, there are other great features, but for me, for growth, Calc is taking a better approach.
- shamney 12y agowhat were you not able to accomplish with vba? you can use c# with excel as well. http://exceldna.codeplex.com http://exceldna.codeplex.com