How to stop pop when calling macro from python
<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>