VBA 146

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

Sorted from new to old.

RGB2HTML + HTML2RGB

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

2018Jul9

CreateFullTree

Creates full tree if not found

2018Jul9

DuplicateFileName

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

2018Jul7

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

XorC

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

2018Jul1

SharePointURL2Path + Path2SharePointURL

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

2018Jun30

DeleteAllFiles

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

2018Jun30

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

DelOldFiles

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

2018Jun24

Ordinal

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

2018Jun24

NumberTextArabic

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

2018Jun24

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

GetTimeZone

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

2018Jun22

GetUTC

Get the time and date in Universal time based on local time Uses w32tm / tz ...

2018Jun22

DosCommand_Read

Get output of DOS Command in string, by reading output into temp text file, ...

2018Jun22

1 2 ...7 ...9 10