• bagfatnick@kulupu.duckdns.org
      link
      fedilink
      arrow-up
      5
      ·
      1 year ago

      For the backend I used the ADO library to create a MSAccess DB on a shared network folder. Then it’s a matter of using VBA to generate SQL commands to same library to read / write records from the DB.

      For the frontend, I use VBA to generate a HTML document from the fetched data. For the IE control in a user form, you can then write the HTML to it. During this process you can bind local VBA variables to any of the html elements in the page.

      A common flow would be:

      • User clicks an element in a table
      • simple JS on the page does some calculation, stores a value in a hidden input and clicks it.
      • the user form variable detects the click in the monitored element, reads the changes, and acts on it.

      I also have VBScript to act as the launcher by copying the excel file to the local machine, and launching the local copy. This solves the concurrency issue.