VBA-Excel 339
Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
ContainerHTMLTag_ReturnBlock
Returns the full string starting from open tag of container where LocationIndex ...
Concatenate_HTMLColumn
Build a string from a certain column in html table (using < table, < tr, and < ...
CopyFiles Excel-Macro
Simple macro to make sure we have a copy of all files in a folder found in ...
Triangular coded msg in file
Decodes message from file based on number in each line of text. Attached ...
FindAncherURL_InHTMLRow
Finds the URL (href tag value) for an anchor inside a table row (tr element) ...
HTML_InsideTag_ByIndex
Checks if LocIndex is found between open and close of HTMLTag or between close ...
CutString_ReverseFrom
Returns full string starting from the point of LocIndex minus back where we ...
Send workbook as email attachment
Retro way to send a workbook you are in as an email. Found it in one of my old ...
Install/Uninstall SQLNativeClient DB driver
Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...