Random codes

Random 24 Codes by our developers.

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

2018Dec30

DBMySQLVBA API

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

2019Feb3

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

Macro keyboard shortcuts

Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...

2023Dec13

Star rating

Another Bootstrap rating system using Font-Awesome

2019Jun24

gsplit usage

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

2024Feb7

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

2019Jan9

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

2024Feb10

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

RemoveDuplicates

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

2022Jul7

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

2024Jul7

CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

2018Jun22

Capitalize1st

Capitalize 1st letter of a string

2018Jul15

Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

2018Jul7

IsThere_Remote

Checks if a file can be reached online or no Same as

2019Jun7

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

CSS Analog clock

Pure CSS Analog clock, found it in my archive

2019Jan7