Search results 133

Sorted from new to old.

CreateFullTree

Creates full tree if not found

2018Jul9

FindVBAObject

Finds specific VBA object in VBE project User need to setup to trust VBA ...

2018Jul6

NMACode

Converts all Æ¼ found in a string into their actual chars

2018Jun27

RemoveChars

Removes all chars found in Chars_to_remove from String1

2018Jun22

File_FirstFound

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

2018Jun20

HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

2018Jun17

MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

2018Jun16

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

FindName

Finds a name in a workbook, returns true or false

2018Jun10

FindSheet

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

2018Jun7

FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6

CutRightString

Cuts a string from a string FROM RIGHT starting from specific character and ...

2018Jun2

ReplaceChars

Replaces all chars found in Chars_to_remove from String1 with Char_to_put One ...

2018May26

FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22

InsertHyperlinks + GetHref

Converts https found in text into anchers < a > Comes with GetHref as bonus ...

2018May13

IsThere1

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

2018Apr25

1 2 ...8 9