Solid Edge 2D Drafting 2019 - Auto update variables with a driven Excel table

I am currently working on making a Solid Edge Template with variables that are controlled through an excel sheet. When I tried to automate this process through VBA, the variables in Solid Edge didn't update.
Essentially my desired result is:
1. From one excel sheet, open a second excel worksheet and populate it with data
2. Open Solid Edge file
3. Solid Edge File updates to what was populated in the second excel worksheet
4. Close second Excel worksheet
This whole process is automated through VBA
Currently, Step 3 is not working.

Does anyone have an idea as to what my problem is and how I can get the Solid Edge draft to update automatically?

Thanks,