Search results 60

Sorted from new to old.
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
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

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 (aka VMatchIf)

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

Card image
WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

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 ...

Card image
FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...