Here's a VBA script that connects to SAP using SAP GUI Scripting and includes a basic GUI using a UserForm in Excel. The GUI allows users to enter their SAP credentials and execute a simple ...
Template = "Z:\13. Activity\01. Daily\[COMPANY_REPORT_ID] - PRMI374 Rant and Rave Data (ER&R)\[COMPANY_REPORT_ID] - PRMI374 Rant and Rave Data (ER&R).xlsm" session ...