Trouble Loading Bloomberg Addins On Excel Using Python

I am trying to open an excel which is connected to BBG and refresh values. To open an instance of excel and load bloomberg addins, I used a solution from the attached link a while

Solution 1:

Try importing time and putting time.sleep(2) after each command. I found the Bloomberg links sometimes need a second to update.

xlapp = win32com.client.DispatchEx("Excel.Application")
time.sleep(2)
xlapp.RegisterXLL('C:/blp/API/Office Tools/bofaddin.dll')
time.sleep(2)
xlapp.Workbooks.Open('C:\\blp\\API\\Office Tools\\BloombergUI.xla')
time.sleep(2)
wb = xlapp.Workbooks.Open(filepath,None,False)
xlapp.Visible = True
wb_addin = ('C:/blp/API/Office Tools/bofaddin.dll')