VBA 143

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

Sorted from new to old.

ANmaSearch_AnyWord_FromANStr

Checks if string has any word from ANStr inside it Unlike

May26

ANmaCountChars_Direction

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

May24

ANmaRemoveMultiSpace

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

May16

MathInsideText

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

May8

ANmaUploadFTP_Script + ANmaUploadFTP_1File

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

Apr27

VBInstr_Rev_Any

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

Apr11

String_S

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

Apr10

ANmaHideIntoJPG and ANmaExtractFromJPG

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

Apr2

ANString_to_ListSelects

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

Mar24

ListItemText_to_ListIndex

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

Mar24

NumberBeforeString_HTML2

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

Mar20

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

Mar13

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

1 2 ...8 9