VBA 143

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

Sorted from new to old.

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

AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

2018Jun20

DeleteTree

Deletes tree of files

2018Jun19

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

1 2 ...7 8 9