WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

BrowseWorkbook + BrowseWorkbook_Save

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

HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

BrowseFolder

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

GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

FrmAbout

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

FrmAbout.zip

FixPath, IsThere, IsThere1 ...

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

FileDate_Formatted

Using FileDateTime to get file date

Filesin_Coll + Filesin_Cells

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

FindName

Finds a name in a workbook, returns true or false

1FileDB

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

1FileDB.zip

Connect to UDL

Use a UDL to make your connection to a database