Search results 242

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

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

Weighted_Average

Does a weighted average, knowing that mathematical average between two numbers ...

2018Jul7

LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

2018Jul7

Cookies warning

Thanks to new law in Europe, we need to show users and let them accept a ...

2018Jul6

Active BS4 breakpoint

Was looking for some way to show bootstrap 4 breakpoint, and got this

2018Jul6

Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

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

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

2018Jun30

SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

Numeric-only textbox

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

2018Jun27

1 2 ...13 ...15 16