Search results 251

Sorted from new to old.
Card image
DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

Card image
Distance_Calc_fromString

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

Card image
SettingRead_JR

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

Card image
CreateGUID

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

Card image
DelOldFiles

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

Card image
Ordinal

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

Card image
DeleteTree

Deletes tree of files

Card image
RunFromTemp

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

Card image
Reversefile

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

Card image
File_MostRecent

Getting most recent file in a folder

Card image
WaitFor + ShellWait

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

Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image
Multi-line Textbox focus bug

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

Card image
StringFlip

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

Card image
CopyText2Clipboard

Copies text to clipboard using MSForms

Card image
getQueryString

Reading QueryString from JS