VBA-Excel 276 Visual basic for applications that works only in Microsoft Excel, aka macros

Card image cap
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image cap
CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

CopyFiles.zip

Card image cap
Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Card image cap
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Card image cap
DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

Card image cap
NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

Card image cap
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Card image cap
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Card image cap
VBInstr_Numeric

Finds location of 1st numeric character inside string starting from a certain ...

Card image cap
EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...