Stack Overflow
Stack Overflow

Questions tagged [vsto]

Visual Studio Tools for Office (VSTO) is a set of development tools for creating Office automation solutions (add-in or document customization), using .NET and the Visual Studio IDE.

Visual Studio Tools for Office (VSTO) is a set of development tools for creating Office automation solutions (add-in or document customization), using .NET and the Visual Studio IDE.

It is expected that questions about VSTO relate to specific programming problems.

This tag should be used on questions about:

  • How to modify ribbons to behave in a certain way
  • How to certain information about a range of text or shape
  • How to access or modify styles
  • How to deploy add-ins and document customizations, e.g. using ClickOnce or an MSI
  • Writing code for any desktop Office application

This tag should not be used for:

Related Tags:

Links:

6576 questions
222
votes
9 answers

Why am I getting "Unable to find manifest signing certificate in the certificate store" in my Excel Addin?

I've got an Excel add-in project that was created a couple years back in Visual Studio 2008. It's got some changes to be made so I've upgraded to Visual Studio 2010 (the only IDE I am able to use). Not sure if this is causing the problem but it's…
Andy Parsons
  • 2,229
  • 2
  • 14
  • 4
81
votes
7 answers

How to troubleshoot a VSTO addin that does not load?

My VSTO Outlook Add-in suddenly stopped working on one customer machine (it does not load, no error message) and I'm stuck with troubleshooting. The machine is Windows 7 x86, Outlook 2007. The add-in is written with Visual Studio 2008 and uses VSTO…
Heinzi
  • 167,459
  • 57
  • 363
  • 519
77
votes
11 answers

How to open an Excel file in C#?

I am trying to convert some VBA code to C#. I am new to C#. Currently I am trying to open an Excel file from a folder and if it does not exist then create it. I am trying something like the following. How can I make it work? Excel.Application…
tksy
  • 3,429
  • 17
  • 56
  • 61
63
votes
7 answers

Excel Interop - Efficiency and performance

I was wondering what I could do to improve the performance of Excel automation, as it can be quite slow if you have a lot going on in the worksheet... Here's a few I found myself: ExcelApp.ScreenUpdating = false -- turn off the redrawing of the…
Vincent Van Den Berghe
  • 5,425
  • 2
  • 31
  • 40
61
votes
7 answers

How to reference Microsoft.Office.Interop.Excel dll?

I had developed a system that deals with excel sheets in 2006 using MS VS 2005. Now, I can not use the same reference with MS VS 2012. var app = new Microsoft.Office.Interop.Excel.Application(); Workbooks wbs = app.Workbooks;
Moe_Al
  • 621
  • 1
  • 5
  • 5
56
votes
2 answers

Unable to find manifest signing certificate in the certificate store

I signed the assembly with my VSTO 4.0 word add-in with strong name key file .snk and tried to uncheck Sign the ClickOnce manifest but after rebuild it appears again. After I tried to delete lines for ClickOnce manifest in .csproj, .pfx manifest…
Vlad Omelyanchuk
  • 3,021
  • 7
  • 29
  • 35
44
votes
3 answers

Beginning VSTO Development

I'm quite confused with what are the necessary tools for VSTO develpment. Specifically I want to manipulate Excel 2003/2007 documents programmatically. I did quite a lot of VBA before, if you want to relate any answer to that. Few questions I have…
idazuwaika
  • 2,749
  • 7
  • 38
  • 46
40
votes
3 answers

How to unit test Excel VBA code

Does anyone have any experience with unit testing Excel VBA code? I want to introduce unit tests into some legacy Excel VBA code as painlessly as possible. One idea I had would be to use VSTO to call code from inside the Excel workbook. I would…
Dr Zimmerman
  • 419
  • 1
  • 4
  • 5
40
votes
9 answers

How do I get an Excel range using row and column numbers in VSTO / C#?

I think the question sums it up. Given two integers for row and column or four integers for row and column for the two corners of a range, how do I get a range object for that range.
Dan Crowther
  • 495
  • 1
  • 7
  • 11
40
votes
10 answers

Installing Office Customization

Name: From: file:///D:/Samples/TestUpdatedVersion/bin/Debug/TestUpdatedVersion.vsto The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the…
user187229
  • 401
  • 1
  • 4
  • 4
33
votes
1 answer

How can I create a (VSTO) Office 2007 add-in using VS 2012?

Visual Studio 2012 does not appear to support Office 2007 (it only has project templates for Office 2010). If I want to create an add-in compatible with Office 2007, do I need to use Visual Studio 2010, or is there a simple way to do it with VS…
Gary McGill
  • 26,400
  • 25
  • 118
  • 202
32
votes
6 answers

Fastest way to interface between live (unsaved) Excel data and C# objects

I want to know what the fastest way is of reading and writing data to and from an open Excel workbook to c# objects. The background is that I want to develop a c# application that is used from Excel and uses data held in excel. The business…
jw_pr
  • 323
  • 1
  • 4
  • 5
31
votes
28 answers

HRESULT: 0x800A03EC on Worksheet.range

I am getting HRESULT: 0x800A03EC on Worksheet.range method. Number of rows are more than 70K. Office 2007. Code: Microsoft.Office.Interop.Excel.Range neededRange = currentWS.Range[cell.Cells[1, 1], cell.Cells[nRowCount, nColumnCount]]; Here my…
Cannon
  • 2,725
  • 10
  • 45
  • 86
28
votes
2 answers

How to develop a Microsoft Office AddIn without Visual Studio

I'm trying to develop an MS Office Addin in C# .Net and I don't have access to Visual Studio. Instead I'm using SharpDevelop as my IDE, (but my question is equally relevant to anyone developing using any other IDE or compiling from the command…
Iain Sproat
  • 5,210
  • 11
  • 48
  • 68
27
votes
15 answers

Excel error HRESULT: 0x800A03EC while trying to get range with cell's name

I am working with Window Service project. that have to write data to a sheet in Excel file in a sequence times. But sometimes, just sometimes, the service throw out the exception "Exception from HRESULT: 0x800A03EC" while it's trying to get range…
Teerasej
  • 1,486
  • 4
  • 21
  • 31
1
2 3
…
99 100