Extract Hyperlink Addresses in Excel with VBA or Office Scripts

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

Launching a PowerShell Script from Excel, Revisited

We're going to build off my previous series to show how to further the communication channel between Excel and PowerShell. In a recent series of posts, I explained how to launch a PowerShell script ...
Hosted on MSN

2 actions to run script in Excel from Power Automate flows

Within Power Automate, it has been possible to run scripts in Excel using the Run Script action. Did you know that there is a Run Scripts from SharePoint library action too? Office scripts are similar ...
Geeky Gadgets

How to write Excel formulas using the Advanced Formula Environment (AFE)

Excel’s formula bar has limitations that make writing, debugging, and managing complex formulas challenging. A new tool, the Advanced Formula Environment (AFE), developed by Microsoft for Excel 2019 ...