VBA 60 Visual Basic for Application, in most application. Code here can also be used in VBA-Excel

Card image cap
oShellRun1

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

Card image cap
Num2En

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

Card image cap
XorC

Simple small function to Encrypt or Decrypt a string in cell Test_XorC is for ...

Card image cap
SharePointURL2Path + Path2SharePointURL

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

Card image cap
DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

Card image cap
NMACode

Converts all Ƽ found in a string into their actual chars

Card image cap
FullTree

Creates the full tree if needed

Card image cap
DelOldFiles

Delete files in a specified folder which are older than x days This code ...

Card image cap
Ordinal

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

Card image cap
NumberTextArabic

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

Card image cap
RemoveChars

Removes all chars found in Chars_to_remove from String1

Card image cap
GetTimeZone

Get local timezone Uses w32tm / tz dos command in command prompt Using ...