File System 132

File structure, folder, FTPs, local, intranet and a like
Sorted from new to old.
Card image cap
DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

Card image cap
ASCII_Read + ASCII_Save

Reads and saves text file giving its full name Used a lot in my websites, very ...

Card image cap
AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

Card image cap
File_FirstFound

Gets first file found matches a wildcards mask, using Dir()

Card image cap
DeleteTree

Deletes tree of files

Card image cap
IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

Card image cap
BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

Card image cap
EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

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 6 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 ...