Search results 136

Sorted from new to old.

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

FindFile

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

2018Jul11

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

1 2 ...8 9