Search results 115

Sorted from new to old.

RangeTakePicture_Linked

Converts a range in Excel sheet into picture. linked or unlinked. Important! ...

2025Sep30

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

2025May30

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

ANmAddress_Value

Returns the value of a cell address in another sheet. Todo: Allow to reference ...

2024Oct31

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

2024Jun6

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

2024Apr18

1 2 ...7 8