Codes Required

Card image cap
Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

Card image cap
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Dec19

Card image cap
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

Card image cap
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Card image cap
RandomGUID

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

2019Dec18

Card image cap
GenerateRandom

Generates a random string, returns string passed, then full date, then 8-chars ...

2018Sep12

Card image cap
Styles_DeleteNonStandard

Delete styles from an Excel workbook, any non-standard style will be deleted. ...

2018Aug12

Card image cap
RandomImage

Gets a random image from a folder of files, passed as an unMapPathed (HTML) ...

2018Aug10

Card image cap
RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

Card image cap
MetricToUSStandard

Converts a Metric Measure into a US Standard Measure. Arguments: ...

2018Jul17

Card image cap
USStandardToMetric

Converts US Standard Measure into a Metric Measure. Arguments: ...

2018Jul15

Card image cap
RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

Card image cap
RandomNumber

Generate random number between Lower and upper numbers provided

2018Jun28

Card image cap
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

Card image cap
RandomHelloACM

Generate random using web service into ASP variable. With help of PHP, we now ...

2018May13

Card image cap
RandBetween

Generating random number between two

2018Apr25

Card image cap
GetRandom

Generate random string, fully customization, with even deciding what special ...

2018Apr21

Similar codes

Card image cap
MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

Card image cap
WordPress - Excel functions (AI)

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

2023Apr22

Card image cap
DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

Card image cap
DB_SettingRead + DB_SettingSave + ...

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

2018Apr14

Card image cap
RRRow - Datatables ASP mdb Ajax example

ASP based AJAX example to call mdb database using

2020Sep7

Card image cap
DB Class

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

2018Dec25

Card image cap
DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

Card image cap
Connect to UDL

Use a UDL to make your connection to a database

2018May27

Recently by developer

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Random Codes

Card image cap
Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6

Card image cap
notifyjs

Notification messages in js From

2019Jul12

Card image cap
MouseDown and MouseUp in FM20 controls

MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

2019Apr14