Virtuall BLOG tagged 'powershell'

Migrating from VBA to VSTO

hbr@pqr.nl — Thu, 06 Oct 2011 23:00:00 +0100

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.

After the code was translated and connections to CRM were setup, we bound the new standard document to the sharepoint libraries. Now if we create a new document from [...]

Archiving email attachments

hbr@pqr.nl — Tue, 11 Jan 2011 23:00:00 +0100

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.

But a lot of the older mail contains attachments that are outdated and no longer n [...]

Script bits (update 4)

hbr@pqr.nl — Mon, 31 May 2010 23:00:00 +0100

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

None of them are very special but each of them is a result of a short moment of frustration and a few minutes of gvim typing (yes, I use 'vi' on windows too).

so far this article contains:

Add wallpapers from a lot of subdirs to a Windows 7 Theme Change everybody's manager in Active Directory Execute one command on all you [...]