So I've realised where the initial problem is coming from, and have tried numerous ways of attach, activate and shows without any success.
While I was testing the above just to get the functions working, I opened the excel file from Desktop, then run BP and it attaches 100% and everything works...