File System 133

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

Sorted from new to old.

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

2023Aug9

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ReadBinaryBuffer

Reads file in binary mode as blocks Starts reading from start in sequential ...

2023Apr30

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

2023Mar29

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

New VBS file

Add vbs to new menu in Windows Explorer. Fast way to create VBS files using reg ...

2022May3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

1 2 ...8 9