
Icon as text - CmdCaption_ChrW
Creates an icon as text to use inside button or any frm20 controls. this will ...

Calculation_StaleValues
Show Stale function formats or hide Excel recently started to show cells with ...
Icon as text - CmdCaption_ChrW
Creates an icon as text to use inside button or any frm20 controls. this will ...
Fri 8AM
SettingRead+SettingSave
This is the final version of my set of Setting functions SettingRead, ...
Jun30
Windows Common Controls 6.0
This is the needed library to have Windows Common Controls installed to be used ...
Jun30
ImagesIn_Count
Counts number of image files found in a folder Images defined here are files ...
May15
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
May15
ANmaCellChar_Superscript_Subscript
Sets certain character inside a cell as superscript or subscript Edit ...
May15
CountRowCells
Counts how many cells with data in a row, starting from certain column until ...
May12
Match3_3rdNot0
Searches for two cells in two columns then checks for 3rd column if not equal ...
May12
Match4_4thNot0
Searches for three cells in three columns then checks for 4th column if not ...
May12
MatchIfUp or MatchIfRev
Searching for an item in a column from bottom to top. Will search for item in ...
May12
NumberBeforeString_HTML
Cuts a number that would be found before certain word inside a block string. ...
May6
NumberBeforeString_HTML2
Cuts a number that would be found 2 words before certain word inside a block ...
May6
ANmaRedirect
Simple redirecting function, used to direct users from one domain into another ...
Apr24
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Apr14

ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...

DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...

Textbox focus issue fix
Trick to force textbox with multiple lines and scrollbars to refresh itself ...

ASCII_Read + ASCII_Save
Reads and saves text file giving its full name Used a lot in my tools, very ...

DB_SettingRead_Field
Returns a certain field from Settings table by a SettingName. Similar to ...

Admin Counter boxes
4 sets of Admin/Dashboard count boxes, or cards Needed a set for DBRox, and ...

Split string into table
Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

Bootstrap table by wenzhixin
Working jquery bootstrap table, with pagination, search, sort and column ...

Bootstrap IE issue
Looks like IE has some issues in bootstrap 3, this is the solution, please ...

Porting Excel/VBA into OpenOffice Calc
PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

Find and Replace
This will find all occurences of a string in a text file and replace it with ...

RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...

Active BS4 breakpoint
Was looking for some way to show bootstrap 4 breakpoint, and got this. Needs ...

VBA Progressbar (Frm73)
Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Thumbnail generator
Generates thumb image file from a jpg, gif or png, saves it to server, or show ...

MouseDown and MouseUp in FM20 controls
MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

Custom Excel UI ribbon
Excel custom ribbon in details. A good article I use as reference to add custom ...

ANmaUploadFTP_FilesFrom2Columns
Upload files in column each to folder in next column. Expects to have two ...

MatchIf_ThenDelete
Searches for an item in a column, then if found, delete that cell (not clear, ...

ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

Screenshot_IrfanView
Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

Part of cells in Excel
How to modify part of text inside an Excel cell using VBA. Something in my ...

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

WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...

Execute exe embedded in Excel
Execute exe file that embed inside Excel sheet This is for experimental, not ...

Responsive JS Tags
Responsive Tags Input With Autocomplete Examples using Bootstrap 4 Originally ...

ANBSThumbImg + ANBSThumbLink
Creates thumb of an image with or without link to original Use ANBSThumbLink ...

ANma_HTML2DB + ANma_DB2HTML + ...
Convert HTML text into DB-safe string, by converting some characters as below. ...

Page area and Page Setup functions (Unfinished)
Clear Excel print area, or set it, or read it, along with Page setup commands ...

Paging with Alternating Colors
This script will take the results of a query and sets up number of records per ...