Search results 382

Sorted from new to old.

RemoveCommaBetween2Quotes

Removes comma between the first pair of quotations (RemoveCommaBetween2Quotes)

2018Jul24

GetRelativePath

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

2018Jul19

CustomExcelMenu - FaceIDs

How to create custom Excel menu, this one shows the IDs and icons of 20 icons, ...

2018Jul19

URLs2Anchors

All links found inside a string into anchor (< a href=...) BUG!: Currently ...

2018Jul17

CreateAnchor

Creates an anchor by passing its arguments (used to be called URL2A), can ...

2018Jul17

CapitalizeAllWords

Capitalize first letter in all words In a String

2018Jul15

Unzip_7Zip

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

2018Jul14

ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

2018Jul11

Win10 User Folders

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

2018Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

IIF

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

2018Jul7

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

2018Jul6

Num2En

Convert number to English words, convert 450 to 4 hundreds and fifty dollars

2018Jul6

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

2018Jul4

1 2 ...20 ...23 24