Search results 575

Sorted from new to old.

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14

Crypt128

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

2018Jun14

OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

GenerateMemorablePassword

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

2018Jun11

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

Numbers in Textbox

Force textbox to accept numbers only. Needs adjustments to work on VB6

2018Jun6

Time2Real

Converts TIME code to number HH:MM to xx.xx As in 10:15 to 10.25, 13:30 to 13.5

2018Jun2

RGB2Long

Converts Red, Green and Blue integers into RGB long value

2018Jun2

Crypt512

To encrypt or decrypt any string ' Strii is the required text to protect ' ...

2018Jun2

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

1 2 ...33 ...35 36