Videos

VSTA in Microsoft SSIS: Customizing Data Management

craig — Fri, 24 Jul 2009 20:12:00 GMT

(Please visit the site to view this media)

A demonstration showing how to create custom tasks using VSTA in Microsoft SQL Server 2008: Integration Services (SSIS) that exract data from Microsoft Office Excel spreadsheets.

SolidWorks VSTA: Harnessing the Power of .NET

craig — Fri, 24 Jul 2009 20:11:00 GMT

(Please visit the site to view this media)

A demonstration of Microsoft Visual Studio Tools for Applications (VSTA) being used within SolidWorks Premium 2009. Macros that automate tasks are created using VSTA to extend functionality of this MCAD application.

VSTA in InfoPath 2007: Implementing Business Logic

craig — Fri, 24 Jul 2009 20:09:00 GMT

(Please visit the site to view this media)

A demonstration of using VSTA in Microsoft Office InfoPath 2007 to create custom functions in electronic forms.

Revit VSTA: Empowering the End-User

craig — Fri, 24 Jul 2009 20:08:00 GMT

(Please visit the site to view this media)

A demonstration of VSTA's capability to create custom macros in Autodesk Revit Architecture 2010.

AutoProxyGen: From ProxyGen to AutoProxyGen PART 1

craig — Fri, 24 Jul 2009 20:06:00 GMT

(Please visit the site to view this media)

This video demonstrates how to use AutoProxyGen and incorporate it as a build event. Covers problems with ProxyGen handled by AutoProxyGen and feature requests that were incorporated.

AutoProxyGen: From ProxyGen to AutoProxyGen PART 2

craig — Fri, 24 Jul 2009 20:04:00 GMT

(Please visit the site to view this media)

This video demonstrates how to use AutoProxyGen and incorporate it as a build event. Covers problems with ProxyGen handled by AutoProxyGen and feature requests that were incorporated.

Updating VSTA Project Templates Tutorial PART 1

craig — Fri, 24 Jul 2009 19:57:00 GMT

(Please visit the site to view this media)

This tutorial gives step by step instructions on how to update a project template to mimic the ShapeApp sample templates which use a post build event to move add-in assemblies to %My Documents%\ShapeAppCSharp\AppAddIns.

Updating VSTA Project Templates Tutorial PART 2

craig — Fri, 24 Jul 2009 19:57:00 GMT

(Please visit the site to view this media)

VSTA v 2.0 Basic Integration PART 1

craig — Fri, 24 Jul 2009 19:44:00 GMT

(Please visit the site to view this media)

This video demonstrates how to do a basic VSTA 2.0 integration using the SDK sample ShapeAppCSharp. This integration utilizes tools included with the SDK and available for download from Summsoft.com. Steps covered include creating a proxy, registering the host, creating project templates, and updating the host to discover and load add-ins.

Related SDK sections:
Creating Proxies
Registering the Host Application
Creating Project Templates Visual Studio Tools for Applications)
Discovering and Loading Add-Ins

Summit Tools:
AutoProxyGen v 2.0.0.2
VSTA Integration Templates

VSTA v 2.0 Basic Integration PART 2

craig — Fri, 24 Jul 2009 19:26:00 GMT

VSTA and Packaging

Melody — Tue, 07 Apr 2009 15:56:00 GMT

(Please visit the site to view this media)

Packaging is used by Office 2007 documents including the "docx", "docm", "xlsx", and "xlsm" file types. In this sample, the VSTA add-in project source code and compiled assembly are packaged into the single file document which can be transferred (ex: e-mailed) and opened by another user who through the single file will have access to the document, compiled add-in and source code- similar to an Office document with a VBA macro project included.

This sample is document-centric, so the add-in is intended only for use with the document it is packaged within. Based on the ShapeAppDynamicProgrammingModelCSharp SDK sample, this sample extends the existing packaging file format of the SDK samples to include the VSTA add-in associated with the document. Benefits of packaging document specific VSTA add-ins within documents include ease of deployment and an intuitive end user experience.

Link to Sample

MSDN: Add-in Debugging

MSDN: DPM Walkthrough

IPH Demo: Simplifying the IDE

Melody — Wed, 11 Mar 2009 20:15:00 GMT

(Please visit the site to view this media)

Demonstrates customization of the VSTA IDE by using an In Process Host (IPH) to steamline the IDE.

Link to download sample

Link to VSTA SDK IPH documentation

Adding a Hidden File to a Project Template

Melody — Fri, 23 Jan 2009 21:05:00 GMT

(Please visit the site to view this media)

In many situations you want to add background code to a VSTA project template without exposing it to the user. An easy way to do this is to add a hidden code file to the template. Here are the 6 steps to do this which are the same for both C# and VB templates:

1)    Unzip the existing project template.
2)    Add the file to use as the hidden code file to the same folder as all other files in the template (do not put it in a sub folder).
3)    Update the vstemplate file to include the hidden file. Use the same syntax as the main code file.
4)    Update the xxproj file to include the hidden file. Use similar syntax as the hidden xml designer file.
5)    Save and re-zip the updated template, moving the new zip file to the ProjectTemplatesLocation.
6)    Run vsta setup for the host.

Related blog with samples

Demo: Dynamic Programming Model End User Experience

Melody — Fri, 09 Jan 2009 16:51:00 GMT

(Please visit the site to view this media)

This video covers the end user experience of a DPM integration using the VSTA v 2.0 ShapeAppDynamicProgrammingModelCSharp SDK sample. For technical information on the Dynamic Programming Model refer to the VSTA v 2.0 SDK sections Dynamically Creating and Modifying Host Items and Host Objects in an Add-in Project and Walkthrough: Adding Host Items and Host Objects to an Add-in Project.

Demo: Importing XML data with LINQ in VSTA

Melody — Mon, 22 Dec 2008 20:40:00 GMT

(Please visit the site to view this media)

This demo shows how to use LINQ in VSTA to import XML data from Excel.