VBA 75 Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

Card image cap
RGB2HTML + HTML2RGB

Converts RGB color to / from HTML format As bonus, functions RGB_ExtractColor ...

Card image cap
CreateFullTree

Creates full tree if not found

Card image cap
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

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 - 2Delete

Creates the full tree if needed Duplicated with

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 ...