VBA 126

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

Sorted from new to old.

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

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

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

MinOfArray

Gets the id of an item with minimum in an array of numbers, with option

2019Oct20

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

FilesKill

Delete Multiple Files (with WildCards) To delete multiple files from a ...

2019Aug7

ImageOpen_IfranView

Opens an image using Irfanview (i_view32.exe attached which also inscludes a ...

2019Jul8

Screenshot_IrfanView

Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

2019Jun27

1 2 ...4 ...7 8