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

Card image cap
GetRelativePath

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

Card image cap
MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

Card image cap
CutString1

Cuts a string from a string starting from a specific character index and until ...

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