Excel VBA, SOAP, XML and SharePoint – Verify a File Exists (Updated July 25, 2013)

This last week I have been hard at work on a project for a client.  Essentially, the client needed an excel macro which would accomplish this:

1. Open a worksheet found in a predetermined location on a SharePoint Server.
2. Do some stuff with it.
3. Save the worksheet back to the SharePoint Server.

It seems pretty simple, doesn’t it?  SharePoint is Microsoft, Excel is Microsoft, you’d think the two would talk to each other easily; or that Microsoft would build in various classes and methods associated to make linking Excel to SharePoint simple.

Read more

A Solution

Unlike many on the loony left, I like to deal with solutions.  Many solutions I suggest, of course, get dismissed, or attacked, or ridiculed by the left on one level or another, but that is, sadly the nature of the left today.

Read more

In Terms of Customer Service, @westjet Kicks in the Afterburners

I admit it.  I hate packing.  I hate everything to do with packing.  I hate unpacking more.  Unpacking after a vacation is, after all, such a depressing thing to do, because it means that life, along with all the included trials and tribulations associated with it, is returning. Packing sucks mainly because, invariably, I forget…

Read more

The Office Christmas Party

First things first:  Let’s call them what they are.  Christmas Parties.  Not “Winter Celebrations”, or “Holiday Parties”, or “Early Winter Festive Occasions”, but Christmas Parties. One year, my wife’s employer sent out a broadcast email which stated, “this year, our annual winter celebration will be held…” I refused to go. When I was asked why,…

Read more

The End

Columbia stood at the side of the bed.  The beep, beep of the heart monitor pulsed quietly in the background.  It was nearly time.  The nurse sat back quietly, giving Columbia space and privacy so she could she could give her uncle her undivided attention.  The attending physician ducked into the room to check on…

Read more

DataGrator Suite

The Issue: The client had a large dataset of survey results in CSV format, and needed a way to massage the CSV file into a simplified version and import the result into Excel for further processing.  Once imported into Excel, the client needed a way to to aggregate the survey results into standardized results for…

Read more

St. Albert’s Mayor Takes Extremely Low Swipe at Danielle Smith #pcaa #wrp #ableg

Wow. The Mayor of Saint Albert has just tweeted this: [tweet https://twitter.com/stalbertmayor/status/223602665278537731] Now, this is all supposition and speculation, but remember a while back about illegal contributions to the Conservatives from municipalities, which is illegal in Alberta?  I wonder if St. Albert is on that list.  A quick google search does seem to indicate a…

Read more