VBA-Excel 384

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

Sorted from new to old.

Triangular coded msg in file

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

2024Mar4

FindAncherURL_InHTMLRow

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

2024Mar4

DateDateDate

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

2024Mar3

NumberNumberNumber

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

2024Mar2

HTML_InsideTag_ByIndex

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

2024Feb28

CutString_ReverseFrom

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

2024Feb27

VBInstr_Numeric

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

2024Feb25

EdgarCIK

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

2024Feb25

CutString11

Cuts long string from certain character to certain character with option to ...

2024Feb24

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

FindLinks xla

Excel Addon to find links in workbook. FindLinks v13.2 From

2024Feb9

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

2024Jan23

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

1 2 ...8 ...23 24