VBA 122

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel
Sorted from new to old.
Card image cap
ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

Card image cap
QuarterNumber_FromDate

Returns the number of quarter from a date

Card image cap
ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Card image cap
DecimalPlaces

Returns how many decimal places the number have

Card image cap
IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Card image cap
ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Card image cap
ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Card image cap
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Card image cap
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Card image cap
ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Card image cap
CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Card image cap
Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

Card image cap
ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Card image cap
HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

Card image cap
NumberBeforeString

Cuts a number that would be found before certain word inside a block string. ...

Card image cap
VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...