File System 99 File structure, folder, FTPs, local, intranet and a like

  2. Categories
  3. File System
Card image cap
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image cap
BrowseFolder

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

2018Jun14
Card image cap
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11
Card image cap
FixPath, IsThere, IsThere1, GetPapa, GetSon

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

2018Jun11
Card image cap
Filesin_Coll + Filesin_Cells

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

2018Jun10
Card image cap
DownloadFile

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

2018May22
Card image cap
FilesIn + FilesIn_Count

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

2018May22
Card image cap
GetExtension

Gets the extension of file from its filename

2018May12
Card image cap
IsThere1

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

2018Apr25
Card image cap
FileSize_Formatted

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

2018Apr25
Card image cap
FilesIn + FilesIn_Count

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

2018Apr23
Card image cap
Copy File

Copys a file from one location to another using WSH

2018Apr23