Random codes

Random 24 Codes by our developers.

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

IsThere1_Image

Searches for an image and return the file extension of found, or returns null ...

2019Dec7

jQuery filtering

jQuery filtering, demo From

2019Jul9

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

Win10 ThisPC Virtual locations

I hate it when Windows forcing us to have additional items in "This PC" So, I ...

2024Feb5

RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29

CreateAnchor

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

2018Jul17

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

Hourglass

A js/css hourglass loading spinner

2019Jan5

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

DateSerial

The equivalent of DateSerial in Classic ASP

2018Jul19

Slickmap

CSS only flow chart site map From

2019Aug8

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

ANStrFind_AndOrAdd

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

2023Dec19

TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

2019Jun2

Save to, Read from, Delete registry key

Save into registry, read from registry or delete a key. Accessible to only ...

2019Jun15