Search results 61

Sorted from new to old.
Card image
LoadPicture_Safe

Loads an image into VBA image control without knowing its extension If file ...

Card image
DuplicateFileName

Generates new available file name for a certain file in order to duplicate it, ...

Card image
FindVBAObject

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

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

Card image
CanAccessVBA

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

Card image
HaveNonEnglish + StringASCIIs

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

Card image
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image
MatchIf (aka VMatchIf)

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

Card image
FixPath, IsThere, IsThere1 ...

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

Card image
FindIn1DArray

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

Card image
CutRightString

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

Card image
FilesIn + FilesIn_Count

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