Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

Resources.zip

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

MultiRead_JSON

Reads array of arrays from the parent and return back ANString of 3 columns