VBA 123

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

Sorted from new to old.

VBInstrRev

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

Jan24

CreateThumbSquare_IrfanView

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

Jan18

ANStringListRead_JSON

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

Jan9

SettingRead_JSON

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

Jan8

CutString9

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

Jan7

HTMLPadding_or_Margin

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

Jan5

CutString7

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

Jan1

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

SearchinHTMLTable

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

2023Nov12

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 3 ...7 8