Random codes

Random 24 Codes by our developers.

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

Laoding Circle

Loading animation in css/js

2019Jan5

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

2020Mar31

Tabs13-BS3

Tabs in Bootstrap3

2019Apr7

FS_CopyFile

Copies a file

2018Jun24

UnMergeFill

Unmerges all merged cells and duplicate cell contents into them. In another ...

2019Apr16

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Feb19

Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

Date Month icon

Calendar icon, or date icon, in pure css, used

2019Jan11

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

OpenOffice Calc

OpenOffice programming with Visual Basic Some document I had for my reference.

2019Jan5

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

gsplit usage

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

2024Feb7

CutString3

Cuts string from a larger one based on a specific separator.

2018May29

MSSQL backup

The practical way I found to backup database (or tables) to be moved into new ...

2019Jan6

Posts Per Year

Create summary list If you have SQL table named Table_Name, with DateAdded ...

2018Sep22

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

ClearAllCookies

Clears all cookies created by Linkedin login, and clear sessions

2018Apr23

TrimLines

Remove all line breaks from text from a text. Not like

Jan31

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7