Blog by PQR

Tag >> powershell

Migrating from VBA to VSTO

Posted by: hbr in vstovbascriptpowershelloffice on

It was long overdue but we finally made the move away from Visual Basic for Applications (Microsoft Office scripting). We implemented Sharepoint 2010 and were still using the old fashioned VBA code that originated from Office 2003. So we got Visual Studio out and started translating the VBA code into Visual Basic dotnet.


I had a discussion last week with a colleague about archiving messages in outlook. I have a 7GB mailbox on the server because I never delete mail. That may seem overdone but it has served me well a couple of times in discussions we had. Besides, I see absolutely no point in archiving mail away from the mail server to another store on some fileserver that eventually lands on the same central storage.


Script bits (update 4)

Posted by: hbr in scriptpowershellesxbashActive Directory on

This post is a quick gathering of a few small scripts I wrote with my IT-life's motto: "Never do anything twice"