Search results 269

Sorted from new to old.

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

CreateZipFolder_7Zip

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

2018Jul14

Win10 User Folders

I hate it when Microsoft takes back some controls it already gave to users, one ...

2018Jul9

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

2018Jul9

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

2018Jul5

PI

Returns a double representing the mathematical constant Pi

2018Jul5

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

RandomArray

Creates array of random numbers, returns 1 Dim array

2018Jul2

DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

2018Jun30

Numeric-only textbox

Allow only Currency into textbox, text box will allow only nnnn.nn where n=1 ...

2018Jun27

CellSave (SimpleSave)

Saves value to cell without deformation and converting Used to be called ...

2018Jun26

TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

2018Jun25

ShowAgain2

Make selected item in listbox to be displayed at center of listbox after ...

2018Jun24

1 2 ...15 16 17