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.

DateOffset_FromMMDD

Calculate the new MMDD from a date formated as MMDD after adding/subtracting ...

Apr9

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

2025Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

2025Jul27

CutString_JsonKeyValue

Reads value from json string for certain key. Using RegEx Regular Expression. ...

2025Jul27

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

2025May26

ANmaCountChars_Direction

Counts how many times we found OfChar repeated in TheStr from one of two ...

2025May24

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

2025May16

MathInsideText

Return string after applying math to each number found inside the string. ...

2025May8

ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

2025Apr27

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

Hide files into jpg and restore it using those two functions. Attached file ...

2025Apr2

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

2025Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

2025Mar24

NumberBeforeString_HTML2

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

2025Mar20

1 2 ...9 10