I want to create a macro that can extract the tool ID, tool name, and all relevant information from the configuration window and output it into an Excel file. This macro should be designed to work with any workflow, generating the required results consistently. Could someone explain how to achieve this?
You could try adapting the Parse Customer Managed Telemetry workflow from Help -> Sample Workflows -> Governance Enterprise Utilities. It essentially takes the whole XML that is stored for your workflow in the yxmd file and extracts and parses the tools from your workflows.
It's designed to operate on a telemetry folder, but you could adapt it to point at a single workflow.