Search results 64

Sorted from new to old.

UnMappath

Returns the virtual path of the absolute path specified in the required ...

2018Aug26

Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

2018Aug14

Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

FindFile

Finds if a workbook is open or not in same Excel session

2018Jul11

FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

2018Jun26

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

DelOldFiles

Delete files in a specified folder which are older than x days This code ...

2018Jun24

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

ANStrColor2RGB + RGB2ANStrColor

Converts R:G:B into RGB value (as long) and RGB from long into R:G:B

2018May30

FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

Create and Write Log File

The subprocedure can be called by any ASP applicaiton/page which needs to ...

2018Apr14

1 2 3 4