VBA 135

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

Sorted from new to old.

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

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

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

DelFiles

A very simple to delete a directory and the entire files and folders in its ...

2020Apr1

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

1 2 ...4 ...8 9