COM Enumerations

[lukedays]

Hi Steven!
I searched the source but couldn't find any clues... How can I reference COM enumerations? (such as xlCalculationManual)

https://docs.microsoft.com/en-us/office/vba/api/excel.xlcalculation

Thanks in advance!

[cunnane]

Using pywin32/win32com it's like this:  ``` import win32com.client as win32 win32.gencache.GetClassForProgID('Excel.Application') # May not need this, depending on context win32.constants.xlCalculationManual  ``` I could make this slightly cleaner I agree.

[lukedays]

Thanks a lot!
Full code for reference:

import xloil as xlo
import win32com.client as win32


def calc_manual():
    xl = get_app()
    xl.Calculation = win32.constants.xlCalculationManual
    xl.EnableEvents = False
    xl.ScreenUpdating = False
    xl.DisplayStatusBar = False


def calc_auto():
    xl = get_app()
    xl.Calculation = win32.constants.xlCalculationAutomatic
    xl.EnableEvents = True
    xl.ScreenUpdating = True
    xl.DisplayStatusBar = True


def get_app():
    return xlo.app().to_com()