Excel Formulas and Macros

Is Workbook Open Function

by Scott Lindsay on February 27, 2010

The following Function has been designed to check if a workbook you are about to open is already open. If it is then it will return TRUE, if not then the Function will return FALSE and your other Macro code should then open the workbook that is required.
[click to continue…]

Change Cell Formats using Ranges and Offset

by Scott Lindsay on February 7, 2010

The following Macro has been designed to read through a range of cells and update the Cell formats for Font, Color, Borders and Background Color. This type of Macro can be really useful in worksheet updates where inserts, updates and deletion of cells can result in a loss of formatting for the worksheet. With this Macro the formats can be re-applied with one command after all the updates are made.
[click to continue…]

{ 0 comments }

Copy Email Items to Excel Workbook

by Scott Lindsay on February 7, 2010

A regular request from many  of our customers is the ability to copy Email Items from Outlook to an Excel Workbook. Here is an example of a routine that we use to copy details of a formatted email to an Excel workbook. It is run from within Outlook after selecting the Mail Items that need to be processed.

Note : You will need to specify your own Excel Workbook and Mail Item formats in order to process the records. For most implementations you will be presented with a warning from Outlook that a process is trying to access Email Addresses, to continue accept this warning.

[click to continue…]

{ 0 comments }