IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

IsThere1_Remote

Checks if a file is found from a URL, finds a file in a remote server

IsThere1_Folder

Checks if a folder is found or not, can pass either mapped path or unmapped ...

RunFromShared

Check is this VBA-Excel file is running from a shared folder (Starts with \\) ...

FindFile_Word

Finds a file within open documents of current instance

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

RemoveHTMLTags

Remove HTML tags from a string, note, this won't handle html encoding.

FindFile

Finds if a workbook is open or not in same Excel session

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip