Using .NET library in VBA

Three easy steps for exporting .NET functionality to VBA: 1. Write a source file:   using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.InteropServices; using System.Windows.Forms; namespace InteropTest { [Guid(“BEB2C62D-5646-4B08-81DF-670314BFEE4A”)] public class InteropTestClass { public void Help() { MessageBox.Show(“Hello From .NET!”); } } } The GUID needs to be unique. 2. Generate a strong…

1

List styles in Word document with preview

  The sample code from my previous post does a pretty good job listing the styles in a Word document. However, having a preview of these styles makes it a lot easier to spot the subtle differences than by using the Description object. For generating a preview of the styles I used some code posted…

0

Listing styles in Word document

  When dealing with Styles in Word you can never have too much control. This is when a listing of the existing styles and their descriptions helps a lot. Happily VBA provides a powerful way of getting details about a certain style through the Description member of the Style class. Based on this I’ve built…

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