Microsoft is considering adding Python as one of the official Excel scripting languages, according to a topic on Excel's feedback hub opened last month. Since it was opened, the topic has become the ...
Office Scripts extract Excel hyperlink URLs without macros; results are hardcoded so the file can stay .xlsx, reuse is straightforward.
Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...