Search results 250

Sorted from new to old.

Distance_Calc_fromString

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

2018Jun27

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

2018Jun26

CreateGUID

Generate random GUID of 36 chars (with or without brackets) using TypeLib ...

2018Jun25

DelOldFiles

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

2018Jun24

Ordinal

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

2018Jun24

DeleteTree

Deletes tree of files

2018Jun19

RunFromTemp

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

2018Jun17

Reversefile

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

2018Jun16

File_MostRecent

Getting most recent file in a folder

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15

Multi-line Textbox focus bug

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

2018Jun7

StringFlip

Flips a string, right-to-left, and if passed again, will flip it back Can be ...

2018Jun2

CopyText2Clipboard

Copies text to clipboard using MSForms

2018May30

getQueryString

Reading QueryString from JS

2018May29

Hex2Bin

Converts Hex to Binary

2018May28

1 2 ...14 15 16