|
|
In our previous post on Find and FindNext we saw that in combination they can be used to search through large amounts of data very quickly.
In many cases we need to use Find and FindNext on a worksheet. The best way to implement repeatable and automated worksheet based functions is through User Defined Function (UDF). This is just a function written in VBA code that can be used on a worksheet.
[click to continue…]
Working with large amounts of information in Excel can depending on the functions used be very inefficient. One of the most useful and powerful functions for searching large amounts of data is Find and FindNext. These functions will help you scan through information and quickly source the results needed.
In this post we will describe how Find can be used to optimise your spreadsheets..
[click to continue…]
The following module is an interface which prompts the user of the document to select a text file from a pop up dialog box (similar to the Open or Save As window). Once the file is selected, the pathname and document name is recorded. This pathname/filename can then be used to automatically open the text file and further coding used to import and format the data. This macro is particularly useful for reporting purposes where data is imported on a regular basis.
{ 0 comments }
The following Function has been designed to check if a chart already exists in the open workbook. If it does exist then it will return TRUE, if not then the Function will return FALSE. Based on this function your other code can then create the chart if needed or use the existing chart.
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.
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.
{ 1 comment }
