VBA 148

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

Sorted from new to old.

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

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

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

IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7

WebBrowser control issue

Issue and fix in webbrowser control

2020Feb3

1 2 ...5 ...9 10