.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Office Add-Ins: Develop Add-Ins For PowerPoint And Visio Using VSTO

Posted By:      Posted Date: August 21, 2010    Points: 0   Category :ASP.Net

Microsoft Visual Studio 2005 Tools for the 2007 Microsoft Office System is more powerful than ever, allowing you to create add-ins for Word, Excel, Outlook, PowerPoint, Visio, and InfoPath.

Paul Stubbs

MSDN Magazine February 2007

View Complete Post

More Related Resource Links

Office Apps: Integrate VSTO with SharePoint Content Types


See how to build a document-level Visual Studio Tools for Office customization and integrate it with a content type in SharePoint.

Steve Fox

MSDN Magazine May 2008

VSTO 3.0: Developing Office Business Apps with Visual Studio 2008


With custom form regions in Outlook you can pull in data from designated data sources and truly customize your users' Outlook 2007 experience.

Steve Fox

MSDN Magazine Launch 2008

VSTO: Build Office-Based Solutions Using WPF, WCF, And LINQ


With Visual Studio Tools for Office you can easily build Office-based services that harness the power of Windows Communication Foundation, Windows Presentation Foundation, and LINQ.

Andrew Whitechapel

MSDN Magazine December 2007

Office Apps: Extend Your VBA Code With VSTO


VSTO brings you the full feature set of Visual Studio including LINQ, WPF, WCF, and the .NET Framework 3.5.

Paul Stubbs and Kathleen McGrath

MSDN Magazine August 2007

OFFICE UI: New VSTO Features Help You Customize Word And Outlook


See how to use Microsoft Visual Studio Tools for the Microsoft Office System to build powerful custom applications against the 2007 Microsoft Office system.

Steve Fox and Paul Stubbs

MSDN Magazine June 2007

Office 2003: Host an Interactive Visio Drawing Surface in .NET Custom Clients


Microsoft Office Visio 2003 introduces a new drawing component that allows you to embed an interactive drawing surface into your application's user interface. You can drive the Visio drawing component from events in your host application or with data from a Web Service and an ADO.NET data adapter. The Visio drawing component supports the rich Visio application programming model, giving you control over how graphics are used and displayed on the drawing surface. This article explains how to embed the Visio drawing component into a C#-based Windows Forms client app that retrieves data from the Fabrikam 2.0 Web Service.

Mai-lan Tomsen Bukovec and Blair Shaw

MSDN Magazine December 2003

Using Microsoft.Office.Interop.PowerPoint

Hi, Im writing a web application  that uses Microsoft.Office.Interop.PowerPoint. When I execute the application from VS 2008 it works fine. I have a .pptx template, I create an instance of PowerPoint, then I open the Presentation, add a Slide and finally I add an excel file as an OLE Object. The code that I'am using is something like this:Imports Microsoft.Office.Interop.PowerPoint Imports PowerPoint = Microsoft.Office.Interop.PowerPoint Dim objPowerPoint As PowerPoint.Application Dim objPresentacion As PowerPoint.Presentation Dim objDiapositiva As PowerPoint.Slide objPowerPoint = New PowerPoint.Application objPowerPoint.Visible = Microsoft.Office.Core.MsoTriState.msoCTrue objPresentacion = objPowerPoint.Presentations.Open("File.pptx") objDiapositiva = objPresentacion.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank) objDiapositiva.Shapes.AddOLEObject(10, 10, , , , "ExcelFile.xlsx") objDiapositiva = Nothing But when I want to execute the application from my localhost I get an error in the AddOLEObject method, the error is something like: HRESULT E_FAIL of a COM component call I don't know what is the problem because from VS 2008 it works fine but from localhost it does not work, all in the same computer. Can anyone help me? Thanks!    

Creating an Office Plan ECMAScript Mashup Drawing in Visio 2010 to Display in SharePoint Server 2010

Learn how to use the Visio Services ECMAScript API to create a floor plan drawing in Visio Premium 2010 in a Web Parts page in SharePoint 2010.

Office Web Apps: Failing at loading a PowerPoint for Viewing or Editing


Greetings all,

As of this morning, we've started to receive reports that users can't load PowerPoint presentations in MS Office Web Apps. In all standard browsers (IE, FFox, Chrome), the load fails with an unexpetected error.

There have been no system changes for several weeks now -- wondering what went wrong? Any ideas of how to fix? Reinstall... er... web apps?!? We're totally baffled, and bummed that such a helpful piece of functionality went ... erm... poof!


p.s. Viewing MS Word Documents still works - thankfully!


Error message: 


Unhandled exception caught when executing web method handler: System.NullReferenceException: Object reference not set to an instance of an object. 
 at Microsoft.Office.Web.Environment.Sharepoint.SharepointServiceLoadBalancer..ctor(OfficeServiceType serviceType, UInt32 refreshIntervalSecs) 
 at Microsoft.Office.Web.Environment.Sharepoint.SharepointServiceInstanceFinderAdapter.GetLoadBalancerForService(OfficeServiceType serviceType) 
 at Microsoft.Office.Server.Powerpoint.Pipe.Web.WacViewServices.BeginGetItem(RequestParams requestParams, String itemId, Stream stream, AsyncCallback callback, Object state) 
 at Microsoft.Office.Server.Powerpoint.Pipe.Interface.ResourceRequest.Begin(AsyncCallback callback, Object state) 
 at Microsoft.Office.Server.Powerpoint.Pipe

Office Web Apps Powerpoint Network Connectivity issue



After installing and deploying office web apps on an existing sharepoint 2010 farm, I'm facing an issue with PowerPoint web App.

Namely when I try yo open a presentation in browser, after maybe 30sec I get the following message :  "Network connectivity has been lost. Check your network connection or try again later.". I looked into the SharePoint logs and I found multiple iterations of the following record :

Windows=False, Ntlm=True, Digest=False, Basic=False, Anonymous=False 85c0870e-4a45-4266-96be-c28495c122a7
04/08/2011 18:08:38.09  w3wp.exe (0x3720)                        0x0DA4 Office Web Apps                PowerPoint Web Services        d34t Medium   Checking parent web supported authentication of instance:192398217 Endpoint:http://***/_vti_bin/ppt/view.svc/jsonNegotiate 85c0870e-4a45-4266-96be-c28495c122a7

More interesting I found the following entry Windows Application Log:

WebHost failed to process a request.
 Sender Information: System.ServiceModel.ServiceHostingEnvironment+HostingManager/48657371
 Exception: System.ServiceM

Office Web Apps 2010 for SharePoint Foundation will not View Word or PowerPoint File


I have installed a SharePoint Foundation 2010 in a Farm environment and installed Office Web Apps 2010. I have not been able to view Word documents or PowerPoint documents inside of the web browser. I can view Excel documents okay and I can edit a Word doc in the browser.


Does anyone have any suggestions as to what may be the problem?

Daryl Gilbert II

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

How to run Office macros by using Automation from Visual Basic .NET

This step-by-step article describes how to call Office macros from a Visual Basic .NET Automation client.

You can use Microsoft Office Automation to open a document or create a new document that contains a Visual Basic for Applications (VBA) macro and execute the macro at run time.

Microsoft Office Excel cannot open or save any more documents because there is not enough available


hi all,

     i am new to asp.net programming i am trying to create an ms excel file with charts drawn in it,

i wrote the complete code for it but the it is saying

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 

i have set the permissions to my complete disk space and all user accounts, and i tried with anti-virus disabling also it didnt work please try to help me out and my code is :

Imports System.Data.OleDb
Imports Microsoft.Office.Interop
Imports Microsoft.Office.Tools.Excel
Imports System

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

Office Services: Merging Word Documents on the Server Side with SharePoint 2010


Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010

Office Space: Custom Field Types for SharePoint 2007


Custom field types provide a powerful way to define a reusable SharePoint column definitions.

Ted Pattison

MSDN Magazine May 2009

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend