Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » COM AddIns   (RSS)
Friday, October 02, 2009 6:33 PM

Excel: How do you use RefEdit/range selection control to select a cell range using .Net

In Excel VBA, we could use RefEdit control on a user form for allowing users to select a cell range on worksheets. This control allows users to select a range easily just by dragging on Excel cells and it can be passed as an input (as range object) to
Posted by Obuli Mani J | 0 Comments
Filed under: , ,
Friday, October 02, 2009 6:27 PM

Excel: How do you implement Application_Quit event in Excel/how do you intercept Excel application Quit

We know Word Object model provides an event handler called Application_Quit, which will be triggered when the application quits, but we don’t have any such events for Excel (even for PowerPoint and some other Office applications). In order to workaround
Posted by Obuli Mani J | 0 Comments
Filed under: , ,
Friday, October 02, 2009 5:59 PM

Excel: How to run C# code behind with a click of a button on a Worksheet, without VBA code

OLE object controls such as Command button, Checkbox, etc., allow us to call VBA code behind using OnAction property. However, when a situation arises that we have to call .Net code behind, we cannot use OnAction property, because this property requires
Posted by Obuli Mani J | 0 Comments
Filed under: , ,
Monday, March 16, 2009 2:07 PM

Word 2003 SP3 throws intermittent error - There is insufficient memory. Save the document now

Summary An application automating Word 2003 SP3 intermittently throws below exception from Open method: "System.Runtime.InteropServices.COMException (0x800A13E9): There is insufficient memory. Save the document now." Symptoms Error Message: There is insufficient
Posted by Shiv Khare | 2 Comments
Tuesday, April 22, 2008 2:10 PM

Troubleshooting COM Add-In load failures

This post helps troubleshoot Office COM Add-In load failures. As there can be many factors contributing to the failure, it is necessary that we be methodical when we approach this issue to ensure we haven’t missed anything simple.
Posted by Praveen Bengeri | 8 Comments
 
Page view tracker