Search results 524

Sorted from new to old.
Card image
File_MostRecent

Getting most recent file in a folder

Card image
BrowseWorkbook + BrowseWorkbook_Save

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

Card image
GetColumnName, ColumnName_XOffset

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

Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

Card image
BrowseFolder

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

Card image
OpenPassword + ClosePassword

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

Card image
GenerateMemorablePassword

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

Card image
FixPath, IsThere, IsThere1 ...

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

Card image
Col2Combo

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

Card image
Filesin_Coll + Filesin_Cells

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

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
Modify SQL table

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

Card image
Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

Card image
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image
Multi-line Textbox focus bug

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

Card image
FindIn1DArray

Returns 1 if an item found in array, 0 if not