Comments
Richard Davies wrote: The UK has a good crop of technology pioneers in cloud computing - for example ElasticHosts, FlexiScale, Flexiant, OnApp - and also some strong government initiatives such as G-Cloud. We will have to see whether this kind of technical leadership converts into swift mass-market adoption or not.
Cloud Expo on Google News

SYS-CON.TV
Cloud Expo & Virtualization 2009 East
PLATINUM SPONSORS:
IBM
Smarter Business Solutions Through Dynamic Infrastructure
IBM
Smarter Insights: How the CIO Becomes a Hero Again
Microsoft
Windows Azure
GOLD SPONSORS:
Appsense
Why VDI?
CA
Maximizing the Business Value of Virtualization in Enterprise and Cloud Computing Environments
ExactTarget
Messaging in the Cloud - Email, SMS and Voice
Freedom OSS
Stairway to the Cloud
Sun
Sun's Incubation Platform: Helping Startups Serve the Enterprise
POWER PANELS:
Cloud Computing & Enterprise IT: Cost & Operational Benefits
How and Why is a Flexible IT Infrastructure the Key To the Future?
Click For 2008 West
Event Webcasts
Visual Studio Tools for Office 2003
Are We Having Fun Yet?

The following editorial will have little or nothing to do with the content of this issue. Admittedly, it will be about development and, in fact, it will be about development using .NET. However, I will leave it to Patrick Hynds, this issue's Guest Editor, to focus your attention on security - which is the primary topic of this issue. For further information on this, please see his Guest Editorial.

I would like to take this opportunity to provide you with yet another case study in what I like to call "COM Wrapper Insanity." This is a phenomenon whereby one attempts to use technology provided by Microsoft, believing it to be pure managed code, only to find that it is, in fact, just a series of COM wrappers, in various states of repair.

I have mentioned this in the past in reference to the System.Management and System.DirectoryServices namespaces. Unfortunately, I quickly found that I was largely alone in spending 99% of my time coding with these namespaces. Therefore, few people were able to relate to my pain.

A few weeks ago, I began working with Visual Studio Tools for Office 2003, building some advanced spreadsheet functionality for Excel 2003. I quickly encountered similar pains, but it occurred to me that many more of you might be able to relate to this situation, since Office is, by far, the most popular desktop productivity tool on the planet.

My struggles began as I tried to find out how to include .NET in my Excel spreadsheet. I was disappointed to see that the only documentation actually in Excel itself for programmability was still for COM-era VBA. I was further disappointed to find that the mechanism for including my code consisted of just adding a couple of custom properties to the workbook - which yields no deep integration, or even any way to easily browse for my assemblies.

Once I realized that the objects were only documented in their VBA COM-era form, I was ready to proceed and found that the COM wrappers in VSTO 2003 were generally well named and intuitive. My next bit of trouble came when I wanted to iterate through a collection of objects. Since I'm a C# coder, of course I figured that I would use the foreach nomenclature provided for this purpose. However, since the collection in question was not a true .NET collection, but merely a COM wrapper itself, this call failed.

The result of this was that I had to implement a for-next loop that counted the number of items and iterated through them by position in the array. Unfortunately for my purposes, I was deleting some items from the array as I progressed. The end result was an irritating bug in my code that would never have materialized if I had been able to use the normal .NET foreach construction.

My final gripe - for the moment - is that exceptions are completely swallowed by Excel 2003. I don't know whether this is a function of its COM origins or not, but I can tell you that I had an insanely hard time troubleshooting some bugs until I realized this.

The good news is that VSTO 2005 is on its way, and I have been promised that it will be much better and less COM. Here's hoping!

About Derek Ferguson
Derek Ferguson, founding editor and editor-in-chief of .Net Developer's Journal, is a noted technology expert and former Microsoft MVP.

In order to post a comment you need to be registered and logged in.

Register | Sign-in

Reader Feedback: Page 1 of 1

Latest Cloud Developer Stories
Rackspace Hosting, the service leader in cloud computing, on Thursday announced its acquisition of SharePoint911, an industry leader in SharePoint consulting, training, and "JumpStart" services within SharePoint. The unification of both companies provides capabilities to deliver ...
With Cloud Expo 2012 New York (10th Cloud Expo) now under four months away, what better time to start introducing you in greater detail to the distinguished individuals in our incredible Speaker Faculty for the technical and strategy sessions at the conference... We have techn...
Nimble, the social CRM platform has announced the launch of Nimble 2.0, billed as the “most social” CRM platform on the market today. Nimble was designed entirely with social CRM in mind and is the first social business platform that empowers companies with the ability to get clo...
2011 was a year of rapid adoption for public and private cloud services. Instant and on-demand server provisioning was the driving force behind the massive growth. On top, cloud server templates and script automation simplified application installation for simple and pre-defined ...
"Having been in the IT field for many years, I believe the cloud computing chapter in the industry is an exciting one and I am proud to be a part of it," said National Reconaissance Office (NRO) Chief Information Officer Jill T. Singer Tuesday, as it was announced that she was on...
Subscribe to the World's Most Powerful Newsletters
Subscribe to Our Rss Feeds & Get Your SYS-CON News Live!
Click to Add our RSS Feeds to the Service of Your Choice:
Google Reader or Homepage Add to My Yahoo! Subscribe with Bloglines Subscribe in NewsGator Online
myFeedster Add to My AOL Subscribe in Rojo Add 'Hugg' to Newsburst from CNET News.com Kinja Digest View Additional SYS-CON Feeds
Publish Your Article! Please send it to editorial(at)sys-con.com!

Advertise on this site! Contact advertising(at)sys-con.com! 201 802-3021

SYS-CON Featured Whitepapers
ADS BY GOOGLE