SAP GUI VBA Extraction Macro

I need a VBA-driven macro that connects to SAP GUI, navigates through the required transactions, and pulls the data I routinely use for management reports. The goal is to eliminate the manual export process so that, with one click, the latest figures land in a structured worksheet ready for analysis.

Key points
• Environment: classic SAP GUI (not Fiori or web).
• Task: extract data for reports; the macro should log in, run the existing transaction sequence, grab the result set, and drop it straight into an Excel workbook (a different flat-file format is fine too if it simplifies the build).
• Reliability: the script must handle common pop-ups, session time-outs, and variable line counts without breaking.
• Maintainability: clear, well-commented VBA and a brief guide so I can adjust field selections or destination ranges later on.

Deliverables
1. Fully functioning .xlsm file (or standalone .bas module) containing the SAP GUI scripting logic.
2. Setup notes covering any security settings that must be enabled in SAP and Office.
3. Short screen-share hand-over to prove the extraction works on my machine.

The sooner this can be tested in my sandbox system, the better, but accuracy and stability come first.