So after a long struggle i managed to create a VBA that would return a workbook variable for me to catch from the Invoke VBA activity.
Te issue is that now on Uipath i get a System.__ComObject and i need a type of UiPath.Excel.WorkbookApplication in order for me to carry on working.
Any ideas?