vsto - w3toppers.com

How to perform .Onkey Event in an Excel Add-In created with Visual Studio 2010?

“I would like to run some code when users presses a combination of keys.” Its tricky and to do it without any external dependencies resort to Keyboard hooking to achieve it with a VSTO Excel Add-in: Imports System Imports System.Runtime.CompilerServices Imports System.Runtime.InteropServices Imports System.Windows.Forms Friend Class KeyboardHooking ‘ Methods <DllImport(“user32.dll”, CharSet:=CharSet.Auto, SetLastError:=True)> _ Private Shared … Read more

Detecting a password-protected document

I have created an utility method that tries to detect if a given office document is protected by a password or not. Here are the list of advantages: supports Word, Excel and PowerPoint documents, both legacy (doc, xls, ppt) and new OpenXml version (docx, xlsx, pptx) does not depend on COM or any other library … Read more

Detecting text changes in Word 2016 from VSTO add-in

Everthing should work fine if you don’t use a low-level hook in your VSTO add-in. [DllImport(“kernel32”, CharSet = CharSet.Auto, SetLastError = true)] public static extern int GetCurrentThreadId(); const int WH_KEYBOARD = 2; private static IntPtr SetHook(HookProcedure procedure) { var threadId = (uint)SafeNativeMethods.GetCurrentThreadId(); return SetWindowsHookEx(WH_KEYBOARD, procedure, IntPtr.Zero, threadId); } Please note that you probably also need … Read more

Iterating through all the cells in Excel VBA or VSTO 2005

If you only need to look at the cells that are in use you can use: sub IterateCells() For Each Cell in ActiveSheet.UsedRange.Cells ‘do some stuff Next End Sub that will hit everything in the range from A1 to the last cell with data (the bottom right-most cell)

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

Where the range is multiple cells: Excel.Worksheet sheet = workbook.ActiveSheet; Excel.Range rng = (Excel.Range) sheet.get_Range(sheet.Cells[1, 1], sheet.Cells[3,3]); Where range is one cell: Excel.Worksheet sheet = workbook.ActiveSheet; Excel.Range rng = (Excel.Range) sheet.Cells[1, 1];

How to send a mail using Microsoft.Office.Interop.Outlook.MailItem by specifying the From Address

You are using outlook to send the mail. Since outlook must be configured to use the from address of your mail, you cannot provide the from address directly. However, you can select an account available on outlook. For example : using Outlook = Microsoft.Office.Interop.Outlook; Outlook.Accounts accounts = olkApp1.Session.Accounts; foreach (Outlook.Account account in accounts) { // … Read more

Excel CustomTaskPane with WebBrowser control – keyboard/focus issues

Ok I was able to fix the issue using the following code protected override void WndProc(ref Message m) { const int WM_PARENTNOTIFY = 528; if(m.Msg == WM_PARENTNOTIFY && !this.Focused) { this.Focus(); } base.WndProc(ref m); } I added this function to my TaskPaneView which is simply a UserControl with that webbrowser child. I don’t have a … Read more

Beginning VSTO Development

Yeah, it can get confusing, especially given the skip-level naming conventions, etc. Essentially, you’ll need: Full version (not Express) of Visual Studio and the .NET version you’re targetting. One of the VSTO run times (VSTO 2003, VSTO 2005, VSTO 2005 SE, VSTO 2008, VSTO 2010). For what your asking, VSTO 2005 SE is probably your … Read more

How to know if a cell has an error in the formula in C#

Dealing with CVErr values in .NET is a very tricky subject. The problem is that .NET (rightfully) regards CVErr as obsolete with respect to error handling. CVErr values, however, are still used in Excel cells, so this is a rather large omission for Excel automation. Fortunately, there is a workaround. The way to check for … Read more

Please explain why I am able to instantiate the “Application” interface in Excel VSTO

The compiler allows you to instantiate interfaces if they’re decorated with a CoClass attribute identifying the concrete class that implements them (as well as a ComImport and a Guid). When you instantiate the interface, you would actually be instantiating this concrete class behind-the-scenes. This “feature” is intended to be used as plumbing for COM imported … Read more