Search results 64

Sorted from new to old.

CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

2018Jul17

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

FindFile

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

2018Jul11

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

2018Jul7

FormulasFlatten

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

2018Jun30

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

TextPercentageMatch

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

2018Jun26

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

FGColor_Calc

To set the color of the foreground based on background color to get best look. ...

2018Jun20

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

Number_Formatted

Format the number as ' <1000 = 1,2,55, 85, 989 ' <1000000 = 1K, ...

2018May26

FA5Icon_FromExt

Gets FontAwesome 5 icon for a file using its extension Used in MyDev website

2018May12

FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25

FileDate_Formatted

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

2018Apr25

ClearAllCookies

Clears all cookies created by Linkedin login, and clear sessions

2018Apr23

1 2 3 4