RangeValues

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

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 ...

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

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 ...

MultiRead_JSON

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

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...