WorkbookOpenAsk_ANmar

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

CreateZipFile_7Zip

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

Resources.zip

CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za,exe (found in attached zip) ...

Resources.zip

FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

File_MostRecent

Getting most recent file in a folder

FixPath, IsThere, IsThere1 ...

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

Filesin_Coll + Filesin_Cells

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

RoundUp

Rounds a number up, like Excel function RoundUP

Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

frmCal.zip