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

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.