A running instance of EA can be accessed from a Python script with something like: However, this seems to always returns the COM object of the instance first started. Let’s say we have a script that needs to starts a new instance of EA. It does so by calling os.startfile(eapxFile) with eapxFile being the path to an empty EA file.
Tag: com
Python win32com constants
I’m currently wondering how to list the constants in win32com in python, for example using excel win32com.client.Dispatch(‘Excel.Application’) Is there a way to display all constants using win32com.client.Constants ? Or does someone know where i could find win32com’s documentation ? Because all the links I found are dead … Answer To find out what Com applications you can use… See http://timgolden.me.uk/pywin32-docs/html/com/win32com/HTML/QuickStartClientCom.html
python win32 COM closing excel workbook
I open several different workbooks (excel xlsx format) in COM, and mess with them. As the program progresses I wish to close one specific workbook but keep the rest open. How do I close ONE workbook? (instead of the entire excel application) Answer The the Workbook COM object has a Close() method. Basically, it should be something like: The above