Search results 71

Sorted from new to old.

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

ScrapeURL_ToSheet

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

2023Apr4

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

RemoveDuplicates

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

2022Jul7

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

URLDecode

Decodes a URL encoded string back into the original text. Similar to ...

2020Aug21

Multi-Level BS4 menu

Another Multi-level menu, this one in Bootstrap 4 and is activated by clicks ...

2020Aug13

1 2 3 4 5