Now that we have our web service, lets get started by writing a managed UDF that uses the web method “GetColumnValue”. In fact, the UDF will mirror this web method and make it so we can use it in Excel formulas. First, add a new C# or VB class library project to your solution using File > Add > New Project. Name the project BugAddIn
Original post:
3. VSTO Bug Tracker : A UDF
Within Microsoft, there is a web service already implemented that I can use in my solution to call the bug tracking system and get back the data described in the previous article. For my demo, I’m going to implement a demo web service that will stand in for that internal Microsoft web service. It will return the same basic data structures as the internal web service does, so when I run my own copy of VSTO bug tracker, I can swap out this demo web service for the real one. The demo web service will have three web methods. The first method is called BulkDataExport. This method takes a start date and an end date and returns back a dataset with all the bug data for that time period. This is a simplified version of the Microsoft provided web service that I use internally. That web method has more parameters to specify milestone, release, team, etc. But I will omit those for simplicity since my data is specific to my team. <WebMethod()> _ Public Function BulkDataExport( ByVal dateFrom As String , _ ByVal dateTo As String ) As System.Data.DataSet [WebMethod()] public System.Data.DataSet BulkDataExport( string dateFrom, string dateTo) The second method is called to get one particular bug stat value for one particular date. This will be used by the UDF I will write later. This takes a particular team (milestone and release I omit) as well as the name of the column I want to retrieve (e.g.
More here:
2. VSTO Bug Tracker : The Web Service
Saurabh blogs about how to work around an error you get if you published a VSTO solution using VS2008 on a machine running the Windows 7 RC and then you try to install the solution on any machine you will see the following error: “The required version of the .NET Framework is not installed on this computer”: http://blogs.msdn.com/vsto/archive/2009/05/07/issues-with-installing-vsto-projects-that-were-published-from-visual-studio-2008-on-windows-7-rc-saurabh-bhatia.aspx
Excerpt from:
If you are using Windows 7 RC and VSTO you better read this
Many customers have reported issues with installing a VSTO project that has been published with Visual Studio 2008 running on the recently released Windows 7 Release Candidate. If you published your solution using VS2008 on a machine running the Windows 7 RC and then you try to install the solution on any machine you will see the following error: “The required version of the .NET Framework is not installed on this computer” You will see this error even if you have the right version of .Net Framework installed. The issue occurs due to some differences in the publishing mechanism on the Windows 7 RC caused by a missing file in the .Net Framework 3.5.1 which was included in the RC
In previous posts, like Importing a Table from Word to Excel , I showed you how to retrieve content within specific content controls. In these posts, content controls were used to add semantic structure to a document, where this structure aided in retrieving and inserting content
Go here to see the original:
Retrieving Word Content Based on Styles
Gmail has popularized archive as an easy way to keep your inbox clean without trashing email, but if you're using Outlook, archive isn't really an option—by default, at least. Here's how to add archive to Outlook
Read more:
Add a Gmail-Like Archive Button to Microsoft Outlook [Ubergeek]
Although the number of built-in images in Excel is large we still may want to use custom images. Because it exist a great number of inexpensive commercial images packages it is not justified to spend our time to create customized images
More here:
Using Custom Images in Ribbon UI Solutions
With the flexibility to use familiar developer tools like Microsoft Visual Studio , developers will be able to rapidly build applications that use SharePoint capabilities as building blocks for their own applications. … MSDN Blog Postings – http://msdnrss.thecoderblogs.com/
The rest is here:
MSDN Blog Postings » Blog Archive » Setup for Azure Development
At the Office Developer Conference last year Bill Gates remarked , “If you look at the success of our software or any software, this emphasis on it being a platform, reaching out to developers, having great tools has been the key to its success.” Since the beginning, Office has included features which enable developers to extend the Office applications and allow them to become a better functional fit.
The rest is here:
Office client developer enhancements with VS 2010