About Me

My photo
Jody Morgan is a Systems and Software Architect. Since 1999, Jody has developed a distinctive approach to solving business needs with Microsoft Technologies. Jody has worked in the Manufacturing, Retail, Transportation/Logistics, Healthcare, Staffing firms as well as for the Federal Government. Jody is strong in the Windows Application and back office architecture. He has help write coding standards along with patterns and practices for specific clients to fit their needs and unique conditions. Proficient in C# and VB as well as SQL Script. Jody has worked hard to collect a broad knowledge base of both software development and IT infrastructure to blend with his ability to help understand and solve business needs of his clients. Jody is passionate about sharing knowledge and educating the masses. “Knowledge leads to meditation which leads to insight which leads to inspiration. Without Inspiration we would all still live in caves and carry clubs.” -Jody

Friday, February 13, 2009

Cool MS Office Programming Tool For .Net

Have you ever tried to code with Office VSTO? Found it difficult to develop or deploy it? I have spent a great deal of time and energy developing Office Outlook add-ins over the last year. I have successfully done so with the out of the box tools in VS 2008 and VSTO 3.0. Microsoft has done a great job getting VSTO 3.0 to be very powerful and feature rich but I did find some issues that really caused me weeks of headaches and frustration.

But recently I was asked to take what we developed in house and create a deployment package for not just MS Office 2007 but also 2003 and imbed a SQL Express installation and seed data into the MSI.

This presented various problems seeing how I was first using only Office 2007 and deploying internally with the “Click Once” technology.

When I tried to develop an MSI I found it was not very straight forward as one might think. When researching I found 2 really good walkthroughs for deploying MS Solutions using an MSI. Please see Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer (Part 1 of 2) and Deploying Visual Studio 2005 Tools for Office Solutions Using Windows Installer: Walkthroughs (Part 2 of 2) if you are interested in trying this yourself from scratch.

Otherwise you may want to take a look at this 3rd party vendor who created a nice VS add-in and Project Templates to help not only deploy but also make it version independent. The company is called Add-In Express. Their tools are by far some of the best I have found and as far as the cost.

Ease of use is phenomenal also. They have wizards that will walk you right through project creation and deployment. Also they have real good samples on their entire feature set so that you can get a good idea how to proceed right from scratch.

If you are doing any production worthy coding in MS Office 2003 or 2007 and want ease of development and deployment this is by far the best route to go.

Check them out and let me know what you think.

Welcome to my blog...

Welcome to my blog. I have been resistant of blogging for some time now. Thinking that is was another fad or toy that would soon go away, you know like the telephone and the television. Much to my dismay is has not so with that in mind I have decided to see how all this new fangled stuff works. I am joining the masses. Moving with the river rather than resisting it.

What do I intend to accomplish with this blog? There are a couple things. First I want to share with the world some, if not all, of my experiences and knowledge. OK so that is done in one or two paragraphs but there is more. I am hoping this blog will stand out from others in that it is a place you can come and share with me in some of my unique discoveries and lessons learned. We live in a fast paced and ever changing world. And the technologies we use are changing and evolving even faster. I believe no one person can know it all. But I do believe that one person can make a difference.

So please read my blog join in the conversations. Add you own spice to the life of this blog. I do ask that everyone be respectful of each other’s ideas and open minded. There is never one right way to do things so please respect the other participants with that in mind.

Thank you for coming and enjoy….