Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.

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 ...

What the Personal Macro Workbook is and why you should care : It is a collection of routines that are available to use in ANY other workbook. If there are certain routines you love, such as for ...