title: Trouble loading Bloomberg addins on excel using python
body: <p>I am trying to open an excel which is connected to BBG and refresh values. </p>
  
  <p>To open an instance of excel and load bloomberg addins, I used a solution from the attached link a while ago 
  <a href="https://stackoverflow.com/questions/57714123/python-using-win32com-wont-update-excel-sheet-with-needed-add-ins">Python using win32com wont update excel sheet with needed Add-ins</a></p>
  
  <p>The solution worked fine for me till yday when for some reason <code>xlapp.RegisterXLL('C:/blp/API/Office Tools/bofaddin.dll')</code> is giving me trouble. i.e. not loading and crashing my codes. </p>
  
  <p>Anyone has any ideas whats happening?</p>
  
  <p>Codes are below if anyone interested</p>
  
  <pre><code>import os, os.path
  import win32com.client
  
  xlapp = win32com.client.DispatchEx("Excel.Application")
  xlapp.RegisterXLL('C:/blp/API/Office Tools/bofaddin.dll')
  xlapp.Workbooks.Open('C:\\blp\\API\\Office Tools\\BloombergUI.xla')
  wb = xlapp.Workbooks.Open(filepath,None,False)
  xlapp.Visible = True
  wb_addin = ('C:/blp/API/Office Tools/bofaddin.dll')
  wb.RefreshAll()
  </code></pre>