You use (UI) macros to automate a series of actions, such as opening another object, applying a filter, starting an export operation, and many other tasks. This article introduces you to the …

You can create a form in Excel by adding content controls, such as buttons, check boxes, list boxes, and combo boxes to a workbook. Other people can use Excel to fill out the form and …

You can use Excel to connect to a wide variety of data sources including Access, SQL Server and Analysis Services databases, text and XML files, and ODBC and OLE DB data sources. …

Whether you're a new user getting familiar with Excel, or an experienced user trying to navigate a large workbook, the Navigation pane can help. Find and access elements such as tables, …

Training: Learn how to create a spreadsheet, enter data, and create a chart in Excel.

A COM Add-in is an in-process COM server (an ActiveX DLL) that must implement the IDTExensibility2 interface. All COM Add-ins must implement each of the five methods of this …

Excel Starter 2010 is very similar to Microsoft Excel 2010 in appearance. If you are new to the Ribbon interface or the Backstage view, Excel Starter gives you an opportunity to get …

Basically, you work with such APIs as CoCreateInstance(), and COM interfaces such as IDispatch and IUnknown. It is important to note that there are some slight differences between …

With user interface (UI) macros in Access web apps you can perform actions such as opening another view, applying a filter, or creating a new record. There are two kinds: “embedded” UI …

You can create a UML component diagram to show components, ports, interfaces and the relationships between them. A component in UML represents a modular part of a system. The …