I have looked at a number of posts and solutions for this issue and just wanted to contribute what worked for me. I usually use my by Excel Scope activity with the Visible option checked but when I was using Invoke VBA I would get a random exception HRESULT:0x800706BE. I noticed if my visible Excel worksheet was not the top app on my desktop then my bot would run to completion. So I unchecked Visible for my Excel Scope activity and that fixed the random exceptions I was getting. I am running the most current UiPath.Excel.Activities 2.16.0 as of 10/17/2022.
Cheers