Search results 193

  2. Search results
  3. used
Sorted from new to old.
Card image
PI

Returns a double representing the mathematical constant Pi

2018Jul5
Card image
GetTempFileName

Returns temp file name using FSO

2018Jul2
Card image
XorC

Simple small function to Encrypt or Decrypt a string Test_XorC is for testing ...

2018Jul1
Card image
Distance_Calc_fromString

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

2018Jun27
Card image
CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26
Card image
DelOldFiles

Delete files in a specified folder which are older than x days This code ...

2018Jun24
Card image
Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24
Card image
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22
Card image
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

2018Jun21
Card image
HaveNonEnglish + StringASCIIs

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

2018Jun17
Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

2018Jun17
Card image
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...

2018Jun16
Card image
WorkbookOpen_ANmar

Opens Workbook in the background with no flickering and with options of ... ...

2018Jun16
Card image
Crypt128

Simple small function to Encrypt or Decrypt a string in cell Simple Encryption ...

2018Jun14
Card image
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7
Card image
Multi-line Textbox focus bug

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jun7
12...111213