.jpeg)
.jpg)
Match5_5thNot0 and Match6_6thNot0
Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...
ConditionalFormatting_ColorARow
Adds conditional formatting to color a row in table based on output of formula ...
.jpeg)
ANmAddress_Dimensions
Detects how many dimensions an address has, This is what I call it dimensions ...
Showing 4k (and more) images in BS5 modal
Allow users to browse and scroll through tons of images to select one (tried on ...
SSL/TLS certificate add/update
Always found myself struggling when applying security to websites for the past ...
Sheet_RowID_Generate + _LastUsed
Generate random unique ID in a column as IDyyyymmRRRR And the second function ...
Match4_4thNot0 v3
Searches for three cells in three columns then checks for 4th column if not ...
Nov13
Match3_3rdNot0 v2
Searches for two cells in two columns then checks for 3rd column if not equal ...
Nov13
ANmaHTMLTables_Combine2 v2
Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...
Oct31
FixPath, IsThere, IsThere1 ... v10
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
Oct31
BrowseWorkbook + BrowseWorkbook_Save v2
Asks for Excel file to open, then return the full filename with path if ...
Oct31
MapPath_SafeComma v2
MapPath version expecting comma in filename or folder. Just because we might ...
Oct26
ANmAddressRefStyle v2
Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...
Sep29
Q_NoOfdays v2
Calculates number of days for certain quarter, starting from given quarter with ...
Aug24
ExportSheets_to_1PDF v2
Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...
Aug15
VBA vs ASP Classic v9
Differences between coding in VB in Classic ASP (aka VBScript) and VBA (aka ...
Aug13
WorkbookOpen_ANmar v3
Opens Workbook without running AutoMacros and without letting the user know ...
Aug13
DosCommand_Read v2
Get output of DOS Command in string, by reading output into temp text file, ...
Aug11
DirsCombo_Read v2
Read directories in a specified folder into a combobox Needs FrmBr having Cbo1
Aug11
HTMLPadding_or_Margin v8
Finds the padding or margin from a style statement for an HTML tag. Passing ...
Aug10
CutLeftNumber v3
Cuts the left part of string as long as it is number Keeps getting characters ...
Aug10
CutString8 v2
Cuts a string from certain character to certain character with option of either ...
Aug3
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
ANBS Controls Set3
3rd set of ANBS controls, Get Set1 here and
IsThere1
Finds out if a file exists, can pass either mapped file path, or unmapped
Navigate
Downloads a certain page source into a variable, full content in HTML, using ...
RoundUp
Rounds a number up, like Excel function RoundUP
FaceIDs
Excel menu icons and icon ids (named FaceIDs) used when yu create toolbars and ...
CutString
Cuts a string from certain char till certain char, can be used to cut left, ...
DB_Read1Row (DB_Read1stRow)
Reads from a table in a DB Reads only the first row, and return a string ...
CreateAnchor
Creates an anchor by passing its arguments (used to be called URL2A), can ...
PI
Returns a double representing the mathematical constant Pi
Num2En
Convert number to English words, convert 450 to 4 hundreds and fifty dollars
MyMonthName
Returns the month name in one of 5 formats (below) It can use full date or ...
FindFile
Finds if a workbook is open or not in same Excel session
Seconds2Time
Converts seconds from numbers into time in format of ...
Floor
Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...
VB6Format
Trying to create VB6 "Format" function in Classic ASP, works now for date only, ...
RemoveHTMLTags
Remove HTML tags from a string, note, this won't handle html encoding.
Hex2Bin
Converts Hex to Binary
Textbox focus issue fix
Trick to force textbox with multiple lines and scrollbars to refresh itself ...
MyDayName
Returns the day name in several formats It uses either full date or only ...
RemoveHTML
Removes HTML code Basically all tags expected and listed below There is a ...
DB_SettingRead_Field
Returns a certain field from Settings table by a SettingName. Similar to ...
ASCII_Read + ASCII_Save
Reads and saves text file giving its full name Used a lot in my tools, very ...
ArrSort_2Arr
Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...
15 Datestamps
15 pure CSS date stamps to be used or Calendar view of a date, something I ...
Admin Counter boxes
4 sets of Admin/Dashboard count boxes, or cards Needed a set for DBRox, and ...
TreeView
A plain pure VBA Treeview control to be used inside Excel (official link has ...
Upload5
Uploading files into server, the simplest way I have here This is the famous ...
Split string into table
Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...
CSS3 spinner3
Pure css3 spinner or pre-loader Originally from http://codepen. ...
Bootstrap table by wenzhixin
Working jquery bootstrap table, with pagination, search, sort and column ...
DB Class
Database Class in Classic ASP An old article I found that helps a lot these ...
Bootstrap IE issue
Looks like IE has some issues in bootstrap 3, this is the solution, please ...
OpenOffice Macros
A pdf book, for macros in OpenOffice.org
Porting Excel/VBA into OpenOffice Calc
PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic
ANmAjax
Trying to simplifying applying AJAX in my websites and tools, this is the ...
FrmLarge v3
Shows an image after clicking on its thumbnail, like in web applications Can ...
Find and Replace
This will find all occurences of a string in a text file and replace it with ...
Navigate
Downloads a certain page source into a variable, full content in HTML, using ...
RemoteExplorer.asp
A directory Viewer with the option of downloading the file and reading text ...
RemoveHTMLTags
Remove HTML tags from a string, note, this won't handle html encoding.
InsertHyperlinks+GetHref
Changes all URLs or email addresses in a text into hyperlinks
Recurse and Rename
Recurses down a directory tree and renames files
Form Maker
This is an application that creates a form in HTML depending on user specs
Active BS4 breakpoint
Was looking for some way to show bootstrap 4 breakpoint, and got this
VBA Progressbar (Frm73)
Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...
Hex2Bin
Converts Hex to Binary
IsHex
Check a string to see if it is Hex
WorkbookSave_ANmar
Saves a workbook handling several scenarios and decide what to do based on each. ...
Prevent Submit until reCaptcha
Disable Submit button until Google reCaptcha is verified, used reCaptcha v2.0 ...
OutlookFolder_DuplicatesCount
Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...
Excel crashes when File > Print
During generating Print Preview, Excel crashes. Applies to some files, not all, ...
Tabindex in multipage
Tabindex and forcing focus to show in textbox if we have multipage control. ...
ConditionalFormatting_ColorARow
Adds conditional formatting to color a row in table based on output of formula ...
Just learnt that now
Looks like we cannot have filename (having no extension) and folder in same ...
Windows Common Controls 6.0
This is the needed library to have Windows Common Controls installed to be used ...
UniqueRandomID in SQL
Generate new Random ID, unique not duplicated in two columns in two tables. ...
VHD files 950MB + 1.8GB + 3GB
VHD files, 950MB, 1.8GB and 3GB, helpful when you want to quickly save files ...
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...
Execute exe embedded in Excel
Execute exe file that embed inside Excel sheet This is for experimental, not ...
Responsive JS Tags
Responsive Tags Input With Autocomplete Examples using Bootstrap 4 Originally ...
ANBS Controls Set3
3rd set of ANBS controls, Get Set1 here and
ANBSThumbImg + ANBSThumbLink
Creates thumb of an image with or without link to original Use ANBSThumbLink ...
Sieve
jQuery plugin to search filter content, customize, easy to apply
From
ANma_HTML2DB + ANma_DB2HTML + ...
Convert HTML text into DB-safe string, by converting some characters as below. ...
ANStrRead + ANStrSave + ANStrSearch
Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...
FixPath, IsThere, IsThere1 ...
Set of 6 functions to deal with filesystem. Gets current workbook path, ...
FilesIn + FilesIn_Count
Returns list of files found in a folder, list separated with custom separator ...
ANStrList functions
Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...
DB_SettingRead + DB_SettingSave + ...
Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...
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
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
Paging with Alternating Colors
This script will take the results of a query and sets up number of records per ...