VBA-Excel 302

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

Sorted from new to old.

DateDateDate

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

Mar3

NumberNumberNumber

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

Mar2

HTML_InsideTag_ByIndex

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

Feb28

CutString_ReverseFrom

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

Feb27

VBInstr_Numeric

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

Feb25

EdgarCIK

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

Feb25

CutString11

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

Feb24

ANStrSort3

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

Feb20

Send workbook as email attachment

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

Feb14

FindLinks xla

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

Feb9

Install/Uninstall SQLNativeClient DB driver

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

Feb8

RangeValues

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

Jan25

PivotTable_ShowHideItems

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

Jan23

PivotTable_ShowHideBlankItems

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

Jan22

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

Jan17

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

1 2 3 ...18 19