Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
All refactorings are useful, but Extract Method, Rename Variable/Method/Class, and Extract Variable will have the biggest impact on your code. I have many good memories of attending the annual Borland ...