.jpeg)
ANmaUploadFTP_ANstrFilesto1Folder
Upload all files found in ANStr list of files into 1 folder. Passing all ...

Create Tree from 3 columns (Sheet2Tree)
Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

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

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 ...
WorkbookOpen_ANmar
Opens Workbook in the background with no flickering and with options of ... ...
Aug7
Excel-VBA Limits
These are some limits I found during my work in Excel-VBA For more of Excel ...
Jul28
Icon as text - CmdCaption_ChrW
Creates an icon as text to use inside button or any frm20 controls. this will ...
Jul18
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
FilesIn_Array and FoldersIn_Array
Return list of files in a folder back as array.
Similar to
May17
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

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

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

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

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

Prevent Submit until reCaptcha
Disable Submit button until Google reCaptcha is verified, used reCaptcha v2.0 ...

CellSave_Hyperlink
Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

Bootstrap Please wait dialog
Bootstrap wait dialog. Shows progress bar asking user to wait while page is ...

CutString_ANmaRules
Extract certain text from another text based on Rules defined, like extracting ...

Input text - pre-Placeholder
Remove text when textbox is selected, then put it back if it left empty This ...

CopyRange_NoClipboard
Copies range without using clipboard. Applies formats into a cell (or range) ...

Tabindex in multipage
Tabindex and forcing focus to show in textbox if we have multipage control. ...

Online JSON Formatter
Online JSON Formatter, helpful when you suck at json, found it during my search ...

ANmaSearch_ApostropheFriends
Searches for string inside string with apostrophe variations conversion

ANmaSearch_QuoteFriends
Searches for string inside string with double-quote possibility If single ...

Filesin_Coll + Filesin_Cells
Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

ANmaSearch_SpaceFriends and LeftSpaceFriends
Searches for string inside string covering multiple possibilities for space ...

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

ANBS Controls Set3
3rd set of ANBS controls, Get Set1 here and

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

Sieve
jQuery plugin to search filter content, customize, easy to apply
From

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