Using DDE in C# for Office automation

  Looking for some code samples how to pass DDE messages from a .NET program I found out that there‘s a great library already in place that facilitates working with DDE: the NDde project from Codeplex: http://ndde.codeplex.com/ However, I just needed to make one call and including a new DLL into my code would have…

0

Complex editing of XLSX files

  Editing Excel OpenXML documents using the OpenXML 2.0 SDK offers better performace and improved supportability compared to normal Office automation (e.g. VBA). There are also great examples on the Internet to get started: Office Open XML Formats: Inserting Values into Excel 2007 Cells. What I haven’t found until now is some clarifications as to…

0

Extra Events for Excel

As a developer of Automation solutions for Microsoft Office one might feel the need of some extra events. Quoting from the MSDN VBA Object Model reference, here is the list of events from the Excel.Application object:  AfterCalculate Event CalculationDone Event NewWorkbook Event SheetActivate Event SheetBeforeDoubleClick Event SheetBeforeRightClick Event SheetCalculate Event SheetChange Event SheetDeactivate Event SheetFollowHyperlink…

0

External links in Excel files

Topic   This is a post that contains a tool for analyzing the external links in an Excel Workbook. The tool is intended to provide information regarding the linked workbooks, the cells from a workbook that contain external links, as well as the target worksheets and cells. It will generate an XML report like this:…

2