Search results 1,199

Sorted from new to old.

FixPath, IsThere, IsThere1 ...

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

2018Jun11

FileDate_Formatted

Using FileDateTime to get file date

2018Jun10

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

FindName

Finds a name in a workbook, returns true or false

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

Frequency

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

2018Jun8

FindSheet

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

2018Jun7

Multi-line Textbox focus bug

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

2018Jun7

Filter_GotoItem

Allow users to select from list box based on search terms. Have a text box and ...

2018Jun7

ComputerSN

Reads Serial number of the system, also can be used to return System name, ...

2018Jun6

FindIn1DArray

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

2018Jun6

Numbers in Textbox

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

2018Jun6

MoveDown + MoveUp

Moves an item in listbox up or down Needs Lst1 as listbox name Put code ...

2018Jun2

1 2 ...69 ...74 75