Search results 964

Sorted from new to old.

BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

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

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

ListBox_SelectedIndexes

Create list of selected items in MSForms listbox as string separated by | Or ...

2018Jun11

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

FrmAbout

Display a string in a Userform as 'About' window, can display string or file by ...

2018Jun11

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Container Switcher

Using Classic ASP and cookies, allow users to personally choose between normal ...

2018Jun10

Col2Combo

Reads everything in a column (starting from certain cell until blank cell is ...

2018Jun10

Filesin_Coll + Filesin_Cells

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

2018Jun10

1FileDB

DB in a File (One of my best library codes so far) Saves/Reads/Deletes certain ...

2018Jun9

Modify SQL table

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

2018Jun9

1 2 ...55 ...60 61