Visual Studio Tools for Office
Discuss and ask questions about using Visual Studio to create managed code solutions for Microsoft Office.
Announcements
- Link
Office Developer Tools for Visual Studio 2012: Now Available with Office 2013 and .NET Framework 4.5 support
I'm pleased to announce that the official Office Developer Tools for Visual Studio 2012 is now available to download! For VSTO developers, this release brings .NET 4.5 support and design-time support for Office 2013, along with general design-time enhancements and bug fixes to the VSTO Runtime (released separately a few months ago via our download center and Windows Update; see KB 2796590 for information regarding the Runtime). We also heard your feedback from "Preview 2" of the tools, including the request to bring back the VSTO Runtime Bootstrapper into VS 2012 -- it is now back in the product.
Office Developer Tools for Visual Studio 2012 also includes tooling for the new apps for Office and apps for SharePoint projects, improvements to SharePoint Workflows, and more. You can read the official announcement for apps-related tooling on Soma’s blog post.
VSTO Office 2013 design-time support in Visual Studio 2012.
Note: Now that's we've added .NET 4.5 support to 2013, we've properly re-categorized the templates in the "New Project" dialog according to the .NET framework version that they support. So, if you're looking for the Office 2010 templates after installing the latest tools, be sure to adjust the ".NET Framework" dropdown to ".NET Framework 4.0". Again, to recap, both the 2010 and 2013 templates support .NET Framework 4.0, but only the 2013 templates support .NET Framework 4.5 -- and the "New Project" dialog respects that categorization.
I hope you enjoy using our new tools! If you have any questions or comments, please don't hesitate to reach out to us.
- Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office
- Link
"New Item" templates not available for VSTO project migrated from VS 2010 to VS 2012
For those migrating a VSTO project from Visual Studio 2010 to VS 2012, there appears to be an issue where Office items (such as the Ribbon) are not available in the converted project. Fortunately, there is an easy fix. See Maarten van Stam's (MVP) blog post http://maartenvanstam.wordpress.com/2012/12/22/office-templates-not-available-in-vs2012-with-converted-project/ for a quick way to resolve the issue.
- Link
Documentation for Office 2013 Ribbon controls now available
Cindy Meister MVPMVPThursday, January 10, 2013 7:49 AMI know the documentation for Office 2013 is still somewhat limited, but hopefully the following link will help.
Microsoft Office Document: [MS-CustomUI2] Supporting Documentation - http://www.microsoft.com/en-us/download/details.aspx?id=727
From here, you should be able to download the *.txt files for Word, Excel and PowerPoint, plus the imageMso information. Once a file is downloaded, it can be opened in Excel to make it easier to look through all the controls.
Best Regards,
Nathan O.
Microsoft Online Community Support - Link
VS2012 & Office2010 solutions: Add-ins disable / Customization could not be loaded
Cindy Meister MVPMVPThursday, December 13, 2012 6:39 AMWe had discovered an issue where add-ins deployed using the ClickOnce method will, under certain conditions, try and fail to install an update, and thereby disable the add-in. For document-level customizations, an exception window with a stack trace may be shown; for application-level add-ins, the add-in will be disabled silently. See the thread http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/495098f8-6364-443a-b2e1-23e650af7e1e.
There is now a NEW VERSION of the VSTO Runtime that fixes the issue. If you're using the web bootstrapper (for add-ins developed using Visual Studio 2010), the bootstrapper will automatically chain in the latest version, so no action is required on your part, or on that of your users. If you're deploying from Visual Studio 2012, you'll need to enable the bootstrapper functionality manually: please see http://blogs.msdn.com/b/vsto/archive/2012/12/21/creating-a-bootstrapper-package-for-an-office-2013-vsto-add-in-with-visual-studio-2012.aspx. Users can also download the latest runtime from http://go.microsoft.com/fwlink/?LinkId=140384.
Installing the new Runtime is a preventative measure, and we highly recommend that all of your users do so! However, this will not fix add-ins that may already have gotten disabled due to the issue. Thus, for users who are already impacted:
If the install location is still accessible (and/or if the developer puts a new version into the same location)
1. Re-run setup from the original network share.
2. Re-enable the Add-In / Doc-Level Customization from within the Office application, as described below.
If the install location is NOT accessible (e.g., network share permanently down, or file was installed off of a USB stick which has since been removed)
1. Launch “regedit.exe” from the start menu / start screen. Navigate to Computer ==> HKEY_CURRENT_USER ==> Software ==> Microsoft ==> VSTA ==> Solutions.
2. There should be several entries there, identified by GUIDs. Click on each entry and check the “ProductName” data until you find the Add-In that you’re trying to re-enable.
3. For the Add-In that’s having problems, double-click on UpdateEnabled.
4. Change the “Value data” to 0 and press “OK”. This will disable Update Checking (and hence cure the problem) until a new version of an add-in is explicitly installed, or until the user repeats the same steps, and sets “UpdateEnabled” to “1”.After editing the Registry, the user should re-launch the Office App (e.g., Excel), and go through the usual steps of re-enabling the add-in (see below).
The usual steps of re-enabling the add-in: (required in either case for any user with currently-disabled add-ins)
1. Open the application’s options (e.g., “Excel Options”) and navigate to the Add-Ins tab.
2. Select “COM Add-ins” from the “Manage” dropdown.
3. Press “Go…”. A window will open.
4. Enable the checkbox for the Add-In(s) that you’d like to re-enable.
5. Click “OK”.
After performing the above steps, the add-in / document-level customization should re-activate in the host application, and also show up in the Control Panel’s “Add or Remove Programs” list.Michael Zlatkovsky | Program Manager, Visual Studio Tools for Office & Apps for Office
Filtering and SortingUse these options to narrow down the question and discussion list.
- 065850

PLEASE READ FIRST - What is VSTO and non-VSTO resources
Cindy Meister MVPMVPSunday, May 25, 2008 10:12 AM - 151028

Deploying Office Solutions to End User Computers
Mary Lee - MSFTMicrosoft EmployeeTuesday, October 21, 2008 4:34 PM - 144915

Visual Studio Tools for Office FAQ Entry List
Ji.Zhou Sunday, February 08, 2009 1:59 PM - 136828

PLEASE READ NEXT - VSTO 2008 Resource List
Cindy Meister MVPMVPSunday, May 25, 2008 11:25 AM - 123776

Audio programs/podcasts available for VSTO
Harry Miller - MSFT Wednesday, June 18, 2008 5:20 PM - 1215664

VSTO deployment scenario to avoid code decompilation
Michael Zlatkovsky Thursday, December 02, 2010 3:24 PM - 78736836

Reading Excel From C#
NewtoCsharp2008 Tuesday, October 11, 2005 10:49 PM - 20231816

Convert .OST to .PST
The MaiN MaN Friday, January 05, 2007 2:12 PM - 34141717

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
IainDowns Wednesday, January 10, 2007 4:14 PM - 18118965

Error HRESULT E_FAIL has been returned from a call to a COM component.
GTrz Thursday, March 02, 2006 9:49 PM - 1102594

How to insert a Date Picker into a MS Excel cell.
Rigo Castillo Wednesday, August 03, 2005 1:25 AM - 3698543

Convert word doc to pdf
mrleokarthik Wednesday, January 10, 2007 11:51 AM - 695675

Exception from HRESULT: 0x800A03EC. at at Microsoft.Office.Interop.Excel.WorkbookClass.get_VBProject()
Siddhartha Dutta Tuesday, April 11, 2006 1:56 PM - 956591

Excel interop The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
ShreyN Wednesday, April 05, 2006 5:34 AM - 1248551

Multithreading in VBA for Excel
MLange2064 Wednesday, November 09, 2005 9:45 PM - 047233

VSTO 2005 & 2003 Resource List
Mike Hernandez - MSFT Tuesday, January 10, 2006 6:35 AM - 847159

Copy Excel Sheet from one Workbook to Other Workbook
n.shah12 Wednesday, June 21, 2006 7:11 AM - 1242500

0x80029C4A (TYPE_E_CANTLOADLIBRARY)
Mallikarjun Kalkere Wednesday, June 27, 2007 5:17 AM - 142157

PLEASE READ FIRST: Non-VSTO Question/Issue Resources
Mike Hernandez - MSFT Monday, December 19, 2005 9:26 PM - 1041941

Print an excel file with c# and print preview control
Ramazan Acar Tuesday, July 04, 2006 3:50 PM - 1341715

imageMso - possible values?
Jan Kučera Saturday, November 18, 2006 10:28 PM - 940417

Creating Excel Report file From VB.Net 2k5 - Help
Simon Darkside Jackson Thursday, May 25, 2006 12:39 PM - 939907

Microsoft.Office.Interop.Excel
NaIsH Thursday, November 15, 2007 2:03 AM - 1139339

How to get char(13)&char(10) in Excel ?
minhhoang Thursday, June 22, 2006 8:03 AM - 2839336

how to turn off outlook security warning dialog box using C#
shiversticks Tuesday, November 22, 2005 7:40 PM - 538697

Type Mismatch error when using Find method in excel
computersciencestudent Tuesday, November 07, 2006 3:49 PM

