My Personal.xls

Here are useful scripts for me. Hope this also helps you.

Title Requirement Comment
Shuffle   An example to shuffle cell values.
ConsoleCommand Excel 95 for Windows An example to run a console command and return the standard output.
nPr   A function to create a list of permutations or combinations.
CopyCFColor Excel 97 for Windows An example to copy cell formats from conditional formattings.
GetApp Excel 97 for Windows An example to create an instance of the specific version of Excel.
CellScreenPos Excel 2000 for Windows An example to get the position of cell in the screen coordinates by using PointsToScreenPixelsX and PointsToScreenPixelsY.
Networkdays2   A function equivalent to the NETWORKDAYS function.
DateDif2   A function equivalent to the DATEDIF worksheet function. (not completely the same)
Arabic   A function to convert from a roman notation to an arabic.
Lock Project Excel 2000 for Windows An example to lock a VB project.
Ruler for Excel   Script to draw a ruler for the active printer.
Export Picture 2 Excel 2000 for Windows An example to export the picture of cell range by saving as HTML format.
Export Picture Excel 97 Export the picture of selected cell range or object by using the Chart.Export method.
Simple Calendar   Create a simple calendar on a worksheet, like this:

Save Picture as WMF Excel 95 or later for Windows Save the picture of cell range or object as Windows Metafile (WMF).
Save Picture as BMP Excel 95 or later for Windows Save the picture of cell range or object as Windows Bitmap (BMP).
Moving border on Userform Excel 97 or later An example to move a border between controls on a userform by mouse-dragging.


Kazuyuki Housaka