VBA 128

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
CalculateQuarterText

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

Card image
Q_NoOfdays

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

Card image
ANmaRemoveNestedTags

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

Card image
HTMLTagID_Previous

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

Card image
NumberBeforeString

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

Card image
VBInstrRev

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

Card image
CreateThumbSquare_IrfanView

Creates square thumb for an image, regardless of image aspect ratio It will ...

Card image
ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

Card image
SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Card image
CutString9

Cuts from CutFrom starting from any of items found from ...

Card image
HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Card image
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Card image
VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

Card image
Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

Card image
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...