Put this script in the same dir as your workbook and run it. You can pass in the workbook name as a link to a wordlist to use however one is defaulted to. This may ...
Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
MarketXLS is an early investment research platform to support MCP for Excel-based financial workflows, helping professionals generate complete Excel analysis workbooks faster than ever.