title: How to stop pop when calling macro from python
body: <p>I have macro code in an excel file and I call this macro using a python code but everytime I call this code it gives me popup(below) which I want avoid as the code is executed from remote machine and the excel file popup is not accessible to the user.</p>
  
  <p>Code:</p>
  
  <pre><code>import win32com.client
  def insert_column():
          fName= 'F:\\Reports\\Logs\\PERF_RESULTS.xlsm'
          xlApp = win32com.client.Dispatch("Excel.Application")
          fTest = xlApp.Workbooks.Open(fName,ReadOnly=1)
          macName = fTest.Name + '!' +'Insert_Column'
          xlApp.Application.Run(macName)
          xlApp.Application.Save()
          xlApp.Application.Quit()
          xlApp = None
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/aklpY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aklpY.png" alt="Popup image"></a></p>