File System 76 File structure, folder, FTPs, local, intranet and more

Card image cap
File_MostRecent

Getting most recent file in a folder

Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

Card image cap
BrowseFolder

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

Card image cap
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

Card image cap
FixPath, IsThere, IsThere1

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

Card image cap
Filesin_Coll + Filesin_Cells

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

Card image cap
DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

Card image cap
FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

Card image cap
GetExtension

Gets the extension of file from its filename

Card image cap
IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

Card image cap
FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

Card image cap
FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator