Enterprise...

Ok, let's go to enterprise level. At a multinational company (or at least i know) Sharepoint is (and let's simplify it a bit) content management application.

Quite powerful when it comes to storing any content. It also provides some workflow management, what gives you some kind of automation tool.

Ohh,if i could forget the workflows of SP2007. 

I had only Sharepoint designer and without, for example, cycle or copy/paste the development is becoming quite pain in the *ss. (If you have solution for this, please drop a comment as my current company does not want to upgrade from SP2007 due to cost awareness.)

But... There is an interesting feature of Sharepoint lists (where you usually store your data),namely export to Excel. There was another feature named synchronize with excel, but it was not working in all Excel/Sharepoint i was working with.

And here we are. Excel has VBA. My most hated programming language of all time. 

But let's put the language aside. VBA sits on top of a brilliant application suite (Office).

So just some idea how you can use the power of VBA:

• combine multiple Sharepoint list in one joint table
• adding extra data processing on the data sits in Sharepoint
• auto generating PIVOT tables on fresh data from SP lists
• send email based on the data
• move mails based on their content
• editing clipboard to paste info based on your data
• downloading files from Sharepoint document libraries 

And so on....

One would ask many of these can be done with server side application. That is correct, but we are on Enterprise level. That also means that it is more difficult to deploy your application.

So be brave enough for VBA (especially when you are not a developer) and save some minute of your work to grab a latte machiatto with your workmates.

Bye!

ps:I can't wait for Typescript in the Office application Suite. :-)