Mydevlib.com

ANmaPairedStrings

Build pairs of lists of strings and returns both strings Takes the worksheet, ...

Mon 5AM

ANStrSearch2

Searches for an item in an ANStrList list by comparing the left part of items ...

Nov3

ExactTop and ExactLeft

Finds the actual distance (Top) of a cell in pixels, and another function for ...

Oct10

ArrSort_6Arr

Sorting 6 arrays same order as 1 array.

Sep9

Vertical vs Horizontal - Edge vs Win11 taskbar

I don't understand you Microsoft. When you updated Microsoft Edge browser few ...

Aug23

Gemini AI Limit reset timer

A simple representative to show me when will my limit reset. Using AI as free ...

Aug15

Recalculate cells with UDF

Force Excel to calculate Cells with UDFs inside VBA code UDF = ...

Aug14

ANmArray_1stMatch_orPartial

Returns the 1st item found in array matching partially the search for value. ...

Aug14

MatchIfUp_DateTime

Finds first cell in column that is a date/time from bottom to top (technically ...

Aug4

Explorers

Open several windows of Windows file explorers (Explorer.exe) to certain ...

Aug2

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

Aug2

ANmarAmdeen

BoldTextbox_Partial

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

Jul16

ANmarAmdeen

ANmaFill

Fill down series in Excel range starting from certain number with certain ...

Jul10

ANmarAmdeen

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Jun1

ANmarAmdeen

v11

HTMLPaddingMargin_v2

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

Jun1

ANmarAmdeen

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Apr26

ANmarAmdeen

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

Apr26

ANmarAmdeen

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

Apr26

ANmarAmdeen

rel nofollow

Outside link no follow. html nofollow of rel No more confusion if it is ...

Feb20

ANmarAmdeen

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Feb6

ANmarAmdeen

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Dec28

ANmarAmdeen

UnicodeToChrW

Converts a Unicode number into its ChrW text. It automatically uses surrogate ...

Nov16

ANmarAmdeen

CutString

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

Nov16

ANmarAmdeen

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2025Aug7

ANmarAmdeen

WorkbookOpen_ANmar

Opens Workbook in the background with no flickering and with options of ... ...

2025Aug7

ANmarAmdeen

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2025Aug7

ANmarAmdeen

Excel-VBA Limits

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

2025Jul28

ANmarAmdeen

Icon as text - CmdCaption_ChrW

Creates an icon as text to use inside button or any frm20 controls. this will ...

2025Jul18

ANmarAmdeen

SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2025Jun30

ANmarAmdeen

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2025Jun30

ANmarAmdeen

VB6Format

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

2025Jun19

ANmarAmdeen

MyDayName

Returns the day name in several formats in Arabic or English language It uses ...

2025Jun14

ANmarAmdeen

MathInsideText

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

2025May22

ANmarAmdeen

FilesIn_Array and FoldersIn_Array

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

2025May17

ANmarAmdeen

13,337

ANBS controls

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

9,411

ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

7,762

IsThere1

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

7,289

Navigate

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

6,935

RoundUp

Rounds a number up, like Excel function RoundUP

6,792

FaceIDs

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

6,733

CutString

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

6,468

DB_Read1Row (DB_Read1stRow)

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

6,461

CreateAnchor

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

6,399

PI

Returns a double representing the mathematical constant Pi

6,388

Num2En

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

6,360

MyMonthName

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

6,343

FindFile

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

6,232

Seconds2Time

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

5,924

Floor

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

5,874

VB6Format

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

5,776

RemoveHTMLTags

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

5,752

Hex2Bin

Converts Hex to Binary

5,650

Textbox focus issue fix

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

5,634

MyDayName

Returns the day name in several formats in Arabic or English language It uses ...

5,617

RemoveHTML

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

5,567

ASCII_Read + ASCII_Save

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

5,564

DB_SettingRead_Field

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

5,553

ArrSort_2Arr

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

4,253

15 Datestamps

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

3,621

Admin Counter boxes

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

2,412

TreeView

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

2,387

Upload5

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

2,194

Split string into table

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

2,071

CSS3 spinner3

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

2,029

Bootstrap table by wenzhixin

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

1,958

DB Class

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

1,955

Bootstrap IE issue

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

1,905

OpenOffice Macros

A pdf book, for macros in OpenOffice.org

1,893

Porting Excel/VBA into OpenOffice Calc

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

1,882

ANmAjax

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

1,816

FrmLarge v3

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

1,787

Find and Replace

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

1,697

Navigate

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

1,691

RemoteExplorer.asp

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

1,689

RemoveHTMLTags

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

1,677

InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

1,676

Form Maker

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

1,676

Recurse and Rename

Recurses down a directory tree and renames files

1,673

Active BS4 breakpoint

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

1,671

VBA Progressbar (Frm73)

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

1,664

Hex2Bin

Converts Hex to Binary

1,662

IsHex

Check a string to see if it is Hex

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Prn

Printout into page, along with additional function to decide where to put the ...

2018Aug5

MovingCaption

CSS-based animation for textbox caption, along with bootstrap 4. From

2020Mar16

Card4-BS4

Simple cards in Bootstrap4 with shadow as lifted corners

2019Mar30

Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...

2020Mar21

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Shareware software window (Frm4)

Show Shareware software
How to use it:
Frm4.ShowMe
Or
Frm4. ...

2018May16

FaceIDs

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

2018Jul9

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

Make HTML File

This script will make a HTML file

2018Apr23

Tabs BS3

Tabs in Bootstrap3, from Bootsnipp, simple and elegant

2019Mar30

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

ProtectFile_XorD + UnProtectFile_XorD

Protects and unprotects a file using password Creates another copy of the file ...

2020Jan10

Reversefile

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

2018Jun16

DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...

2019Apr27

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Rotating Elements

CSS-Only rotating elements, as a slideshow, or carousel From

2019Nov11

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

jQuery Store Locator

Google Maps API implementation using jQuery and json From

2019Jul1

Password Validator

Javascript based password entry validator

2019Jan18

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

Yamm3 mega menu

A bootstrap mega menu Demo:

2019May12

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

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

2023Apr22

GetAmazonPrice

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

2023Apr3

iframeBtn

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

2022May14

ANmaFill

Fill down series in Excel range starting from certain number with certain ...

2022Jan5

A is for Alpha

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

2021Dec6

Special chars

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

2021Oct13

Execute exe embedded in Excel

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

2021Apr16

FeeKey + UnFeeKey

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

2020Nov11

CountDuplicates

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

2020Oct31

Responsive JS Tags

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

2020Oct9

RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

Android Apps and SD memory

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

2020Aug18

Excel-VBA Limits

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

2020Feb5

RandomGUID

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

2019Dec18

ANBS Controls Set3

3rd set of ANBS controls, Get Set1 here and

2019Dec5

ANBSThumbImg + ANBSThumbLink

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

2019Dec1

Sieve

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

2019Jul10

ProfileBadge_Linkedin

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

2019Jun28

VBA vs ASP Classic

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

2019Jun2

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

2019Apr25

ANmaDB functions

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

2019Apr14

My Recommended Apps

4wd.link/Apps List of ...

2019Apr7

ANma_HTML2DB + ANma_DB2HTML + ...

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

2019Feb7

Card12-BS3

Profile card, with social links in bootstrap 3

Card11-BS3

Profile card in bootstrap 3

Card9-BS3

Rounded border cards in bootstrap 3

GetWordCount

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

HttpToAnchors

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

Card4-BS4

Simple cards in Bootstrap4 with shadow as lifted corners

JQMeter

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

Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

Progressbar-BS3

Custom Progressbar in Bootstrap3

Password Validator

Javascript based password entry validator

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

UnMappath

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

SetAttr

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

UserSign

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

MP3GetInfo

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

ServerUptime

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

GetTempFileName

Returns temp file name using FSO

Page area and Page Setup functions (Unfinished)

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

DelOldFiles

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

Reversefile

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

FileDate_Formatted

Using FileDateTime to get file date

Numbers in Textbox

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

getQueryString

Reading QueryString from JS

Connect to UDL

Use a UDL to make your connection to a database