VBA 129

Visual Basic for Application (or macros) in most applications. Code here can also be used in VBA-Excel

Sorted from new to old.

ANmaSearch_AmpFriends

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

2024Jul7

CalculateQuarterText

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

2024Jun10

Q_NoOfdays

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

2024Jun9

ANmaRemoveNestedTags

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

2024Feb4

HTMLTagID_Previous

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

2024Feb2

NumberBeforeString

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

2024Feb1

VBInstrRev

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

2024Jan24

CreateThumbSquare_IrfanView

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

2024Jan18

ANStringListRead_JSON

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

2024Jan9

SettingRead_JSON

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

2024Jan8

CutString9

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

2024Jan7

HTMLPadding_or_Margin

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

2024Jan5

CutString7

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

2024Jan1

ANStrFind_AndOrAdd

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

2023Dec19

VBHTMLInstr

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

2023Dec3

Between_2Chars

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

2023Nov22

1 2 3 ...8 9