File System 145

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

Sorted from new to old.

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

GetAttr

Reads attributes of a file using FSO. Return will be a string of RHSA ...

2018Aug12

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

2018Aug10

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

2018Aug10

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

2018Aug9

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

FoldersIn5

Creates list of subfolders and subfolders of each down to 5 levels Folder ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za,exe (found in ...

2018Jul14

CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

2018Jul14

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

2018Jul14

1 2 ...6 ...9 10