VBA 135

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

Sorted from new to old.

Ask4Folder

Asks user for a folder, starting with certain folder

2018Jul29

List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...

2018Jul26

GetRelativePath

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

2018Jul19

MP3GetInfo

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

2018Jul11

CutString1

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

2018Jul11

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

1 2 ...6 ...8 9