I’ve been playing. I like to play from time to time. I asked myself, a while back, “What if David Lowe had a chance to arrange the Doctor Who theme?” David Lowe is, by the way, the guy who composed the iconic music, “countdown”, for BBC News, and has kept updating it ever since. It’s…
Read moreLatest Seat Projection
Update: Forgot to mention the source of this data: Abacus. Poll date: August 31, 2015. Map colours also updated to make things easier to understand, and added an additional map. (September 5, 2015) Note to mobile users: This program isn’t perfect for you, yet; but I will be adding that functionality in due time. I…
Read moreCSV2XML
A number of years ago, I wrote a Java application which was designed to convert CSV to XML format. The trick being to create an efficient, effective XML document based on the headers of the CSV data. It didn’t turn out well, but I ended up with something that worked and got me started into…
Read moreExcel and WPF
I do a lot of programming. It’s what I do for a living, and it’s also what I do to relax. I know, for many of you, that probably sounds really weird; but I discovered a few years ago that I was dreading waking up in the morning. That was also the time that I…
Read moreExcel and Sharepoint – Revisited
A few months ago, I wrote this blog entry here where I talk about logging into SharePoint, verifying a particular file exists, checking for a lock on the file, and informing the user of the result. Well, after much ado, I finished it. With a lot of swearing, cursing, and hating of SharePoint in general. What…
Read moreExcel 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