Search results 85

Sorted from new to old.

ANma_HTML2DB + ANma_DB2HTML + ...

Convert HTML text into DB-safe string, by converting some characters as below. ...

2019Feb7

MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

2019Feb1

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

Digital Clock

Actually working digital clock JavaScript-based, refreshes every second Found ...

2019Jan3

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

Programming Languages

A nice illustration on different types of languages (the most famous ones only) ...

2018Aug31

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

Seconds2Time

Converts seconds from numbers into time in format of ...

2018Jul11

Weighted_Average

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

2018Jul7

SwapDate

Changes date format from US to International or from international to US. ...

2018Jul5

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

2018Jun27

AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

2018Jun20

HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

1 2 ...5 6