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…]
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 }
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.
{ 0 comments }
