Search results 275

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

DelOldFiles

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

2018Jun24

GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...

2018Jun22

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

DosCommand_Read

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

2018Jun22

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

MatchIf_ThenDelete

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

2018Jun17

GenerateMemorablePassword

Returns a random password that is easier to remember, such as BONES or LAMOT. ...

2018Jun11

Multi-line Textbox focus bug

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

2018Jun7

CutString3_Search

Using same code in CutString3, this will search for matching items. Searches ...

2018May29

CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20

FrmPass

Prompt for a password, or username and password, returns information back to ...

2018May20

List of options (Frm87)

Show list of items with their description from "Settings" sheet Have that list ...

2018May17

1 2 ...17 18