VBA 137

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

Sorted from new to old.

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

Textbox focus issue fix

Trick to force textbox with multiple lines and scrollbars to refresh itself ...

2018Jul29

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

1 2 ...6 ...8 9