Card image cap
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Card image cap
ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

Card image cap
ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Card image cap
ANmaFiles2List

Generating list of files in a folder. One file to do that. I know this has ...

Card image cap
FixURL

Return safe URL after converting critical chars to whatever passed in SafeChar

Card image cap
RegSave, RegRead, RegDelete

Windows Registry read, save and delete branch node or key. Three functions use ...

Card image cap
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Card image cap
Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

Card image cap
Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Card image cap
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Card image cap
CutString12

Cuts string between two numbers that found inside string. Like extract the ...

Card image cap
IsNumericChar

Checks if character is number or no. Returns True or False Number includes the ...

Card image cap
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Card image cap
HTMLdd_Fromdt

Extracts the innerText of < dd > < / dd> for a specific < dt> < /dt> from HTML ...

Card image cap
QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Card image cap
MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

{{$CodeName$}
ANmAddressRefStyle v2

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

Sun 2PM

{{$CodeName$}
ANmAddressSame v2

Checks if passed addresses are referring to same cell regardless of ...

Sun 2PM

{{$CodeName$}
FixURL v2

Return safe URL after converting critical chars to whatever passed in SafeChar

Sep16

{{$CodeName$}
Frequency v2

Checks how many items in an ANStr ANStr is list of items separated by a ...

Sep6

{{$CodeName$}
Choose2 v2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Sep3

{{$CodeName$}
Q_NoOfdays v2

Calculates number of days for certain quarter, starting from given quarter with ...

Aug24

{{$CodeName$}
MyDayName v4

Returns the day name in several formats It uses either full date or only ...

Aug21

{{$CodeName$}
RemoveHTML v2

Removes HTML code Basically all tags expected and listed below There is a ...

Aug19

{{$CodeName$}
ExportSheets_to_1PDF v2

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

Aug15

{{$CodeName$}
VBA vs ASP Classic v9

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

Aug13

{{$CodeName$}
WorkbookOpen_ANmar v3

Opens Workbook without running AutoMacros and without letting the user know ...

Aug13

{{$CodeName$}
DosCommand_Read v2

Get output of DOS Command in string, by reading output into temp text file, ...

Aug11

{{$CodeName$}
DirsCombo_Read v2

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

Aug11

{{$CodeName$}
HTMLPadding_or_Margin v8

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Aug10

{{$CodeName$}
CutLeftNumber v3

Cuts the left part of string as long as it is number Keeps getting characters ...

Aug10

{{$CodeName$}
HTML2Str v2

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

Aug4

{{$CodeName$}
CutString9 v2

Cuts from CutFrom starting from any of items found from ...

Aug3

{{$CodeName$}
CutString8 v2

Cuts a string from certain character to certain character with option of either ...

Aug3

{{$CodeName$}
CutString11 v2

Cuts long string from certain character to certain character with option to ...

Aug3

{{$CodeName$}
CutString97 v2

Cuts part from large string from certain character to certain character with ...

Aug3

{{$CodeName$}
CutString v5

Cuts a string from certain char till certain char, can be used to cut left, ...

Aug3

{{$CodeName$}
ANmaRemoveNestedTags v2

Remove tags that are identical and nested inside each other in an HTML document, ...

Aug2

{{$CodeName$}
VBA Progressbar (Frm73) v2

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Aug1

{{$CodeName$}
Unblock blocked macros. v2

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul28

Card image cap
ANBS controls

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

Card image cap
ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

Card image cap
IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

Card image cap
RoundUp

Rounds a number up, like Excel function RoundUP

Card image cap
FaceIDs

Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...

Card image cap
CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

Card image cap
DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...

Card image cap
CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

Card image cap
PI

Returns a double representing the mathematical constant Pi

Card image cap
Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

Card image cap
MyMonthName

Returns the month name in one of 5 formats (below) It can use full date or ...

Card image cap
FindFile

Finds if a workbook is open or not in same Excel session

Card image cap
Seconds2Time

Converts seconds from numbers into time in format of ...

Card image cap
Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

Card image cap
VB6Format

Trying to create VB6 "Format" function in Classic ASP, works now for date only, ...

Card image cap
RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

Card image cap
Hex2Bin

Converts Hex to Binary

Card image cap
Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image cap
MyDayName

Returns the day name in several formats It uses either full date or only ...

Card image cap
RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

Card image cap
DB_SettingRead_Field

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

Card image cap
ASCII_Read + ASCII_Save

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

Card image cap
ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

Card image cap
15 Datestamps

15 pure CSS date stamps to be used or Calendar view of a date, something I ...

Card image cap
Admin Counter boxes

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

Card image cap
TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

Card image cap
Upload5

Uploading files into server, the simplest way I have here This is the famous ...

Card image cap
Split string into table

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

Card image cap
CSS3 spinner3

Pure css3 spinner or pre-loader Originally from http://codepen. ...

Card image cap
Bootstrap table by wenzhixin

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

Card image cap
DB Class

Database Class in Classic ASP An old article I found that helps a lot these ...

Card image cap
Bootstrap IE issue

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

Card image cap
OpenOffice Macros

A pdf book, for macros in OpenOffice.org

Card image cap
Porting Excel/VBA into OpenOffice Calc

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

Card image cap
ANmAjax

Trying to simplifying applying AJAX in my websites and tools, this is the ...

Card image cap
FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

Card image cap
Find and Replace

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

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

Card image cap
RemoteExplorer.asp

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

Card image cap
RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

Card image cap
InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

Card image cap
Recurse and Rename

Recurses down a directory tree and renames files

Card image cap
Form Maker

This is an application that creates a form in HTML depending on user specs

Card image cap
Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this

Card image cap
VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Card image cap
Hex2Bin

Converts Hex to Binary

Card image cap
IsHex

Check a string to see if it is Hex

Card image cap
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

Card image cap
Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

Card image cap
jui_datagrid

JavaScript driven data grid component

Card image cap
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image cap
Bootstrap 5 cards with responsive images

Bootstrap 5 cards with responsive images From

Card image cap
Cookies Consent

Show cookies message based on new EU regulations with customization. Best one ...

Card image cap
ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

Card image cap
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Card image cap
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image cap
Lychee v3.1.6

A great looking and easy-to-use photo-management-system From

Card image cap
Select2

Select2 a single selectbox implementation Using Bootstrap from

Card image cap
Login modal

Simple modal with login form in Bootstrap 3

Card image cap
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

Card image cap
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

Card image cap
Img not found - Temp pic

Showing image not found if img src image is missing

Card image cap
NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

Card image cap
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

Card image cap
HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Card image cap
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript

Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

Card image cap
BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

Card image cap
Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

Card image cap
Copy File

Copys a file from one location to another using WSH

Card image cap
Porting Excel/VBA into OpenOffice Calc

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

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Card image cap
GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...

Card image cap
iframeBtn

A button in iframe, to run certain command and return status to end user ...

Card image cap
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image cap
A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

Card image cap
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Card image cap
Execute exe embedded in Excel

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

Card image cap
FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

Card image cap
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

Card image cap
Responsive JS Tags

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

Card image cap
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

Card image cap
Android Apps and SD memory

List of apps that can be moved to SD Card in Android OS (Tablet).

Card image cap
Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

Card image cap
RandomGUID

Creates a random GUID number like ... 879AE395-E026-0A63-EFC1-152038C4400B ...

Card image cap
ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

Card image cap
ANBSThumbImg + ANBSThumbLink

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

Card image cap
Sieve

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

Card image cap
ProfileBadge_Linkedin

Creates Linkedin profile badge for certain user as HTML output as string. ...

Card image cap
VBA vs ASP Classic

Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...

Card image cap
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

Card image cap
ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

Card image cap
Card image cap
ANma_HTML2DB + ANma_DB2HTML + ...

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

Card image cap
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Card image cap
SSTree

Tree code, driven by Access DB A code I found somewhere online that I enhanced ...

Card image cap
HTML and URL codes

Always find my self needing to know those quickly to continue working, so ...

Card image cap
Loading gif

Show and hide loading gif using Javascript. a simple way to control when to ...

Card image cap
ANmaVBATemplate

Template to be used for any new tools, having... D sheet, WelcomeSheet, code ...

Card image cap
WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

Card image cap
ANBS controls

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

Card image cap
ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

Card image cap
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image cap
1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

Card image cap
getQueryString

Reading QueryString from JS

Card image cap
ANmaHTMLTemplate

Index.html template having headers with Bootstrap v4.1 and Font-Awesome (BS4.1 ...

Card image cap
FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

Card image cap
ArrayRead + ArraySave

Reading and saving 2 dim data into ANStrArray ANStrArray is a string ...

Card image cap
ANStrList functions

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

Card image cap
DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

Card image cap
Card12-BS3

Profile card, with social links in bootstrap 3

Card image cap
Card11-BS3

Profile card in bootstrap 3

Card image cap
Card9-BS3

Rounded border cards in bootstrap 3

Card image cap
GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

Card image cap
HttpToAnchors

Convert http found inside text into anchers < a >, aka URLlinker, aka ...

Card image cap
Card4-BS4

Simple cards in Bootstrap4 with shadow as lifted corners

Card image cap
JQMeter

A progressbar (or meter) in JQuery, customized with nice options

Card image cap
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Card image cap
Progressbar-BS3

Custom Progressbar in Bootstrap3

Card image cap
Password Validator

Javascript based password entry validator

Card image cap
UnMappath

Returns the virtual path of the absolute path specified in the required ...

Card image cap
SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

Card image cap
UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

Card image cap
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

Card image cap
FileDate_Formatted

Using FileDateTime to get file date

Card image cap
Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

Card image cap
Paging with Alternating Colors

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

Card image cap
Form Maker

This is an application that creates a form in HTML depending on user specs

Card image cap
Make HTML File

This script will make a HTML file

Card image cap
Site Administration

This is an application to administer a website remotely through an ASP

Card image cap
Run Application (ping.exe)

This script uses WSH to open an executable and save the results to a textfile.

Card image cap
List and delete files

Enables users to list and delete files

Card image cap
Email-CDONTS

CDONTS with Attachment Example of CDONTSwith attachment for emailing

Card image cap
Rename Folder

This will rename and or move a folder