Card image
HTMLCloseTag_HasWordAfter

Finds the number of occurrence of a "Numeric" inside a string having a certain ...

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Card image
RoundUp2

Rounds a number to nearest identifier up. Like 105 up to nearest 20 ...

Card image
Walking Columns (Scrollable Columns-Chart)

Allow users to scroll through columns in column-chart. Used chart.js, this is ...

Card image
Font-Based progress bar

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

Card image
ANmAddressSame

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

Card image
ANmAddressRefStyle

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

Card image
ANmaFiles2List

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

Card image
FixURL

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

Card image
RegSave, RegRead, RegDelete

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

Card image
Excel 2408 bug

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

Card image
Get boot time

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

Card image
Choose20

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

Card image
Choose10

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

Card image
CutString12

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

Card image
IsNumericChar

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

{{$CodeName$}
ANmAddressRefStyle v2

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

Sep29

{{$CodeName$}
ANmAddressSame v2

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

Sep29

{{$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
ANBS controls

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

Card image
ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

Card image
IsThere1

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

Card image
Navigate

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

Card image
RoundUp

Rounds a number up, like Excel function RoundUP

Card image
FaceIDs

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

Card image
CutString

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

Card image
DB_Read1Row (DB_Read1stRow)

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

Card image
CreateAnchor

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

Card image
PI

Returns a double representing the mathematical constant Pi

Card image
Num2En

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

Card image
MyMonthName

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

Card image
FindFile

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

Card image
Seconds2Time

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

Card image
Floor

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

Card image
VB6Format

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

Card image
RemoveHTMLTags

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

Card image
Hex2Bin

Converts Hex to Binary

Card image
Textbox focus issue fix

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

Card image
MyDayName

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

Card image
RemoveHTML

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

Card image
DB_SettingRead_Field

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

Card image
ASCII_Read + ASCII_Save

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

Card image
ArrSort_2Arr

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

Card image
15 Datestamps

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

Card image
Admin Counter boxes

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

Card image
TreeView

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

Card image
Upload5

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

Card image
Split string into table

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

Card image
CSS3 spinner3

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

Card image
Bootstrap table by wenzhixin

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

Card image
DB Class

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

Card image
Bootstrap IE issue

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

Card image
OpenOffice Macros

A pdf book, for macros in OpenOffice.org

Card image
Porting Excel/VBA into OpenOffice Calc

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

Card image
ANmAjax

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

Card image
FrmLarge v3

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

Card image
Find and Replace

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

Card image
Navigate

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

Card image
RemoteExplorer.asp

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

Card image
RemoveHTMLTags

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

Card image
InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

Card image
Recurse and Rename

Recurses down a directory tree and renames files

Card image
Form Maker

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

Card image
Active BS4 breakpoint

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

Card image
VBA Progressbar (Frm73)

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

Card image
Hex2Bin

Converts Hex to Binary

Card image
IsHex

Check a string to see if it is Hex

Card image
ASCII_Read + ASCII_Save

Reads or Saves text into file, giving its full path. Same as

Card image
ChrW

Insert special characters inside Cell, using ChrW

Card image
CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

Card image
Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

Card image
SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image
GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

Card image
Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

Card image
Bootstrap Please wait dialog

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

Card image
HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...

Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image
ShowThumb

ASP.Net ShowThumb.aspx file that generates image thumb from an image, official ...

Card image
Bootstrap-Chosen

Drop-down select in bootstrap From

Card image
IsNumericChar

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

Card image
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Card image
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

Card image
CSS Hover effect

Pure CSS hover effect From

Card image
Topcoat breadcrumb

A 3d breadcrumb, menu-like componenet From

Card image
DirectionToggle

JS to switch direction between Right-to-Left and Left-to-Right Toggle the ...

Card image
CutString

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

Card image
IsHex

Check a string to see if it is Hex

Card image
CutString97

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

Card image
FeeKey + UnFeeKey

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

Card image
Numbers in Textbox

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

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
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Card image
SSTree

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

Card image
HTML and URL codes

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

Card image
Loading gif

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

Card image
ANmaVBATemplate

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

Card image
WelcomeSheet

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

Card image
ANBS controls

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

Card image
ANStrRead + ANStrSave + ANStrSearch

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

Card image
FixPath, IsThere, IsThere1 ...

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

Card image
1FileDB

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

Card image
getQueryString

Reading QueryString from JS

Card image
ANmaHTMLTemplate

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

Card image
FilesIn + FilesIn_Count

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

Card image
ArrayRead + ArraySave

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

Card image
ANStrList functions

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

Card image
DB_SettingRead + DB_SettingSave + ...

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

Card image
Card12-BS3

Profile card, with social links in bootstrap 3

Card image
Card11-BS3

Profile card in bootstrap 3

Card image
Card9-BS3

Rounded border cards in bootstrap 3

Card image
GetWordCount

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

Card image
HttpToAnchors

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

Card image
Card4-BS4

Simple cards in Bootstrap4 with shadow as lifted corners

Card image
JQMeter

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

Card image
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Card image
Progressbar-BS3

Custom Progressbar in Bootstrap3

Card image
Password Validator

Javascript based password entry validator

Card image
UnMappath

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

Card image
SetAttr

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

Card image
UserSign

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

Card image
MP3GetInfo

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

Card image
GetTempFileName

Returns temp file name using FSO

Card image
Page area and Page Setup functions (Unfinished)

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

Card image
DelOldFiles

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

Card image
Reversefile

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

Card image
FileDate_Formatted

Using FileDateTime to get file date

Card image
Numbers in Textbox

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

Card image
getQueryString

Reading QueryString from JS

Card image
Paging with Alternating Colors

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

Card image
Form Maker

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

Card image
Make HTML File

This script will make a HTML file