How to dynamically update and run a .bas file with Python?

Question

I have a python script that generates a .bas file which executes a process on SAP GUI. I pretend to run this script everyday to update the .bas file and run it.

I discarded the idea of using a driver (like selenium) to manipulate the SAP GUI directly, because the code is too long and I should refactor all the code.

A solution that I already tried was using the VBA Interpreter SmallBasic, but I got an error:

• COMP-ERROR AT Main:10 *
  Description:
  (EXPR): SYNTAX ERROR (5)

The .bas file starts with:

Sub RPA_YVA05()
Application.DisplayAlerts = False
Dim SapGuiApp As Object
Dim oConnection As Object
Dim session As Object
Dim SAPCon As Object, SAPSesi As Object
Dim SAPGUIAuto As Object, SAPApp As Object

If SapGuiApp Is Nothing Then
    Set SapGuiApp = CreateObject("Sapgui.ScriptingCtrl.1")
End If
If oConnection Is Nothing Then
    Set oConnection = SapGuiApp.OpenConnection("xxxxxxxxxxxxxxxxxx", True)
End If
If SAPSesi Is Nothing Then
   Set SAPSesi = oConnection.Children(0)
End If
    
    'Application.DisplayAlerts = False

 With SAPSesi
        
    .findById("wnd[0]/usr/txtRSYST-MANDT").Text = "0000"
    .findById("wnd[0]/usr/txtRSYST-BNAME").Text = "xxxxxxx"

This generated script already works on Excel, but I want a way faster than opening an Excel file and loading the script manually everyday. Please help me

Answer 1

Small Basic is a defendant language than Visual Basic (which your code is written with). Try using VB6 to run your code, as .bas files are acyualy vb6 modules.