Card image
DBTableCol_Array

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

Card image
PDFDoc - create PDF in ASP Classic

Create PDF in ASP Classic From

Card image
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

Card image
BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

Card image
ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

Card image
FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

Card image
ANStrSort2

Sorting items inside ANStr, this one in ASP Classic (VBScript) Like the VBA ...

Card image
CSS vertical shimmer placeholders

Top-to-Bottom and Bottom-to-Top shimmer placeholders in css During my search, ...

Card image
ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

Card image
Str2Clean

Cleans string. Just another function to clean string from unwanted characters

v3
{{$CodeName$}
MathInsideText

Return string after applying math to each number found inside the string. ...

May22

v2
{{$CodeName$}
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

May17

v2
{{$CodeName$}
ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

May15

v2
{{$CodeName$}
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

May15

v2
{{$CodeName$}
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

May15

v2
{{$CodeName$}
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

May12

v3
{{$CodeName$}
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

May12

v4
{{$CodeName$}
Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

May12

v3
{{$CodeName$}
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

May12

v3
{{$CodeName$}
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

May12

v2
{{$CodeName$}
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May12

v3
{{$CodeName$}
MatchIF5

Searching for rows having 5 values in 5 columns Like

May12

v2
{{$CodeName$}
Column1Range

Return range of cells in column having data where, ignoring header cell and ...

May11

v2
{{$CodeName$}
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May11

v2
{{$CodeName$}
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May11

v5
{{$CodeName$}
NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

May6

v2
{{$CodeName$}
NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

May6

v6
{{$CodeName$}
ANmaRedirect

Simple redirecting function, used to direct users from one domain into another ...

Apr24

v3
{{$CodeName$}
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr14

v9
{{$CodeName$}
HTMLPadding_v2

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

Apr12

v3
{{$CodeName$}
CutString9

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

Apr10

v2
{{$CodeName$}
TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Apr10

v2
{{$CodeName$}
CopyRange_NoClipboard

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

Mar13

v2
{{$CodeName$}
Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

Mar11

Card image
13,337
ANBS controls

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

Card image
9,411
ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

Card image
7,760
IsThere1

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

Card image
7,288
Navigate

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

Card image
6,935
RoundUp

Rounds a number up, like Excel function RoundUP

Card image
6,792
FaceIDs

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

Card image
6,724
CutString

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

Card image
6,468
DB_Read1Row (DB_Read1stRow)

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

Card image
6,461
CreateAnchor

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

Card image
6,399
PI

Returns a double representing the mathematical constant Pi

Card image
6,388
Num2En

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

Card image
6,352
MyMonthName

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

Card image
6,343
FindFile

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

Card image
6,232
Seconds2Time

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

Card image
5,924
Floor

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

Card image
5,872
VB6Format

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

Card image
5,776
RemoveHTMLTags

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

Card image
5,752
Hex2Bin

Converts Hex to Binary

Card image
5,650
Textbox focus issue fix

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

Card image
5,630
MyDayName

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

Card image
5,617
RemoveHTML

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

Card image
5,564
DB_SettingRead_Field

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

Card image
5,563
ASCII_Read + ASCII_Save

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

Card image
5,552
ArrSort_2Arr

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

Card image
4,253
15 Datestamps

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

Card image
3,621
Admin Counter boxes

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

Card image
2,412
TreeView

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

Card image
2,387
Upload5

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

Card image
2,194
Split string into table

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

Card image
2,071
CSS3 spinner3

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

Card image
2,029
Bootstrap table by wenzhixin

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

Card image
1,958
DB Class

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

Card image
1,955
Bootstrap IE issue

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

Card image
1,905
OpenOffice Macros

A pdf book, for macros in OpenOffice.org

Card image
1,893
Porting Excel/VBA into OpenOffice Calc

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

Card image
1,882
ANmAjax

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

Card image
1,816
FrmLarge v3

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

Card image
1,787
Find and Replace

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

Card image
1,696
Navigate

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

Card image
1,691
RemoteExplorer.asp

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

Card image
1,689
RemoveHTMLTags

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

Card image
1,677
InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

Card image
1,676
Recurse and Rename

Recurses down a directory tree and renames files

Card image
1,676
Form Maker

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

Card image
1,673
Active BS4 breakpoint

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

Card image
1,670
VBA Progressbar (Frm73)

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

Card image
1,664
Hex2Bin

Converts Hex to Binary

Card image
1,662
IsHex

Check a string to see if it is Hex

Card image
ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Card image
Tab20-BS3

Nice tabs in bootstrap 3

Card image
ANBS controls

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

Card image
MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

Card image
WelcomeSheet

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

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image
Refreshing image

Refreshing image in ImageControl of VBE Userform When we change picture of ...

Card image
Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

Card image
pd

Format a number with total number of digits I used it to format a date as ...

Card image
Admin Counter boxes

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

Card image
ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

Card image
Connect to UDL

Use a UDL to make your connection to a database

Card image
Arr_1Dim_2Str

Converts 1-dimension array into text. Meet Join. A way to convert array into ...

Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

Card image
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

Card image
Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

Card image
TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

Card image
Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

Card image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Card image
CSS Generators

One of my newest friends in css styling, tons of options. Love the simple ...

Card image
ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Card image
NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Card image
CellSave and CellRead

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

Card image
PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

Card image
DB Functions (By AI)

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

Card image
WordPress - Excel functions (AI)

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

Card image
GetAmazonPrice

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

Card image
iframeBtn

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

Card image
Fill down

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

Card image
A is for Alpha

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

Card image
Special chars

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

Card image
Execute exe embedded in Excel

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

Card image
FeeKey + UnFeeKey

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

Card image
CountDuplicates

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

Card image
Responsive JS Tags

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

Card image
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

Card image
Android Apps and SD memory

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

Card image
Excel-VBA Limits

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

Card image
RandomGUID

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

Card image
ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

Card image
ANBSThumbImg + ANBSThumbLink

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

Card image
Sieve

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

Card image
ProfileBadge_Linkedin

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

Card image
VBA vs ASP Classic

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

Card image
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

Card image
ANmaDB functions

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

Card image
Card image
ANma_HTML2DB + ANma_DB2HTML + ...

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

Card image
0
Card12-BS3

Profile card, with social links in bootstrap 3

Card image
0
Card11-BS3

Profile card in bootstrap 3

Card image
0
Card9-BS3

Rounded border cards in bootstrap 3

Card image
0
GetWordCount

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

Card image
0
HttpToAnchors

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

Card image
0
Card4-BS4

Simple cards in Bootstrap4 with shadow as lifted corners

Card image
0
JQMeter

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

Card image
0
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Card image
0
Progressbar-BS3

Custom Progressbar in Bootstrap3

Card image
0
Password Validator

Javascript based password entry validator

Card image
0
UnMappath

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

Card image
0
SetAttr

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

Card image
0
UserSign

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

Card image
0
MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

Card image
0
ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

Card image
0
GetTempFileName

Returns temp file name using FSO

Card image
0
Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

Card image
0
DelOldFiles

Delete files in a specified folder which are older than x days This code ...

Card image
0
Reversefile

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

Card image
0
FileDate_Formatted

Using FileDateTime to get file date

Card image
0
Numbers in Textbox

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

Card image
0
getQueryString

Reading QueryString from JS

Card image
0
Connect to UDL

Use a UDL to make your connection to a database

Card image
0
Paging with Alternating Colors

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