Search results 78

Sorted from new to old.

Progress in two nested loops

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

2023Mar7

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

OutlookFolder_DuplicatesRemove

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

2023Jan1

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

NMRRank_v2021

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

2021Sep23

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

Nautical/Flight Functions

Functions perform various calculations useful for planning trips. MPH2Kt: ...

2020Oct13

UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

2020May27

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Decode and NVL

Two oracle SQL functions, that are interesting. Decode to work as (Select ...

2020Feb7

ProtectFile_XorD + UnProtectFile_XorD

Protects and unprotects a file using password Creates another copy of the file ...

2020Jan10

GeneratePostID

Two functions to generate ID that is unique (not found in database) ...

2019Dec19

1 2 3 4 5