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

Card image cap
Code128.js

Pure JavaScript library for generating barcodes using HTML5 canvas.

{{$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
ScreenResolution_wxhxtxl

Detects active desktop screen resolution and location of taskbar (with some ...

Card image cap
WaitMe

jquery plugin for easy creating loading css3 animations Simple to use. ...

Card image cap
GetAttr

Reads attributes of a file using FSO. Return will be a string of RHSA ...

Card image cap
NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

Card image cap
ANmaCopy_Objects

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

Card image cap
Bootstrap 4 Date picker

Date and Time picker in Bootstrap 4 From

Card image cap
WinImage.dll

An old DLL library enables reading and writing to floppy disks (and/or images) ...

Card image cap
ArCaptcha

Captcha in Arabic, great library, will look forward to apply it in my next ...

Card image cap
FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

Card image cap
UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

Card image cap
Credit Card form

Javascript-based card form with pure CSS/JS and no images From

Card image cap
SimpleCalendar

HTML calendar, simple, ready for implementing and customizing

Card image cap
RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

Card image cap
Temporary folder in Win10

Where is the Temp folder in Windows 10? Since Windows 7, it has been in the ...

Card image cap
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

Card image cap
Hand.cur

A cursor file type of Hand. used inside VBA to show hand when user hover over ...

Card image cap
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

Card image cap
SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

Card image cap
CSS Analog clock

Pure CSS Analog clock, found it in my archive

Card image cap
ArrSort_4Arr

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

Card image cap
IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

Card image cap
Bootstrap 4 sub-menu

Bootstrap 4 sub menu with no customization From

Card image cap
NumberTextArabic

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

Card image cap
MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

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

Card image cap
Create and Write Log File

The subprocedure can be called by any ASP applicaiton/page which needs to ...

Card image cap
LDAP / SiteServer Migration

This script will migrate LDAP and SiteServer user list to another LDAP ...

Card image cap
Directory Viewer

This is a directory viewer. You can set what files to be viewed. Has ...

Card image cap
GetDigits

Extracts digits out of a string