Search results 47

Sorted from new to old.

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

2018Aug8

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

2018Jul25

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

2018Jul15

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

2018Jul11

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

2018Jul9

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

Returns true if VBA is accessible through code, returns false if not

2018Jun22

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

2018Jun20

Gets first file found matches a wildcards mask, using Dir()

2018Jun20

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

2018Jun18

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

Finds a name in a workbook, returns true or false

2018Jun10

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25