Exceltoolset - exceltoolset.com - Excel Tool Set
General Information:
Latest News:
Free Excel Tool – XLLoop 20 Sep 2011 | 01:10 pm
XLLoop is an open source framework for implementing Excel user-defined functions (UDFs) on a centralised server (a function server).
Get A Specific Element In The Text String With VBA 12 May 2011 | 11:09 am
Often, data is stored in a single worksheet cell consisting of several values, separated by some delimiter. For example, a cell may contain Abby,Barb,Carrie,Dawn, a list of names separated by commas. ...
How to Create A Linkable Hot Image 22 Mar 2011 | 10:26 pm
You might have noticed that some Web sites feature an hot image map to help navigate the site. An image map is a single image, but it’s sensitive to the location at which you click it on hot area. Thi...
Free Excel Tool – VB Template Engine 13 Nov 2010 | 03:17 pm
A compact template engine which written in VB, it uses a simple syntax for template variables and blocks, supports nested blocks and is implemented as a single code module.
How To Highlight Entire Current Row And Column In Excel 9 Nov 2010 | 07:02 pm
This article describes how to highlight entire current row and column in Excel, also you can customize the highlighting color.
How To Get The Data Type Of A Cell In Excel 7 Nov 2010 | 03:47 pm
In some situations you may need to determine the type of data in a cell. Excel provides a number of built-in functions that can help. These include ISTEXT, ISLOGICAL, and ISERROR. In addition, VBA inc...
How to Determine The Type Of A Particular Drive Using VBA 5 Nov 2010 | 11:32 am
This article contains a VBA function that uses the Windows GetDriveType API function to determine the type of a particular drive.
How To Get The Computer Name Or Logged-in User Name Using VBA 4 Nov 2010 | 03:04 pm
This article uses two Windows API functions to return the name of the computer, and the name of the user who is currently logged in. These functions can be used in a worksheet formula, or called from ...
Making A Single Worksheet Function Act Like Multiple Functions 3 Nov 2010 | 10:07 am
This article describes a technique that may be helpful in some situations - making a single worksheet function act like multiple functions.
Getting Coefficients Of Chart Trendline 1 Nov 2010 | 12:18 pm
This article describes how to create formulas that generate the trendline coefficients in Excel's Chart. You can then use these formulas to calculate predicted y values for give values of x.
