Random codes

Random 24 Codes by our developers.

File_MostRecent

Getting most recent file in a folder

2018Jun16

ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

2024Nov17

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

2023Oct7

Tabs25-BS3

Colorful Tabs in Bootstrap 3

2019Apr29

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

CSS3 Progressbar

A progress-bar in pure CSS3, used before we got Bootstrap :-)

2019Jan14

bootstrap 5 Spacelab Dark

A Bootstrap 5 css and scss, Spacelab, dark after modified. Not a toggle, just ...

2023Aug12

User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

2019Feb1

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ANmaTimeline

Creates HTML timeline dynamically, using Bootstrap 4.0 and FontAwesome 5, in a ...

2018Aug26

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

FaceIDs

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

2018Jul9

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

CellSave_Hyperlink

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

2018Aug9

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

FontAwesome Custom icons issue

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

2023Dec29

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29

Tabs2-BS3

Tabs in bootstrap3, custom, easy

2019Feb16

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22