This code example shows how to take data from a worksheet and create a table of contents in an HTML file. The worksheet should have data in columns A, B, and C that correspond to the first, second, ...

In the context of the internal control system, individual control catalogues are provided annualy for different processes. To obtain an overall global overview of all risks and control objectives in ...

When you create a program in Visual Basic for Applications, which comes as a part of several Microsoft Office products like Excel, it may not be immediately obvious how to call those programs from ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

Excel does not always handle a cluttered page very well, especially if you intend to use a workbook on multiple versions of Excel. In this example we will use the Worksheet_SelectionChange event as a ...