File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

DB_Connect_Install.zip

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

DialChart.zip