I would like to open a excel file from a python script, and wait that the user closes the Excel application.
xl = win32com.client.DispatchEx("Excel.Application")
xl.Visible = True
wb = xl.Workbooks.Open(dir+"/my.csv")
wb.RefreshAll()
#wait for xl closes
#continue scripts
But I could find any method in win32com to do it.