import xlwings as xwwb = xw.Book("test.xlsm")msg = wb.sheets("Sheet1").range("A1").valueprint(msg)wb.close()

Private Sub Workbook_Open()    MsgBox "Welcome"    MsgBox "to open"    MsgBox "this file."End Sub

from pywinauto.application import Applicationwin = Application(backend="win32").connect(title="Microsoft Excel")win.Dialog.Button.click()

# listener.pyimport timefrom threading import Thread, Eventfrom pywinauto.application import Applicationclass MsgBoxListener(Thread):    def __init__(self, title:str, interval:int):        Thread.__init__(self)        self._title = title         self._interval = interval         self._stop_event = Event()       def stop(self): self._stop_event.set()    @property    def is_running(self): return not self._stop_event.is_set()    def run(self):        while self.is_running:            try:                time.sleep(self._interval)                self._close_msgbox()            except Exception as e:                print(e, flush=True)    def _close_msgbox(self):        """Close the default Excel MsgBox with title "Microsoft Excel"."""                win = Application(backend="win32").connect(title=self._title)        win.Dialog.Button.click()if __name__=="__main__":    t = MsgBoxListener("Microsoft Excel", 3)    t.start()    time.sleep(10)    t.stop()

import xlwings as xwfrom listener import MsgBoxListener# start listen threadlistener = MsgBoxListener("Microsoft Excel", 3)listener.start()# main process as beforewb = xw.Book("test.xlsm")msg = wb.sheets("Sheet1").range("A1").valueprint(msg)wb.close()# stop listener threadlistener.stop()

pip install pywin32

import win32gui, win32condef _close_msgbox(self):    # find the top window by title    hwnd = win32gui.FindWindow(None, self._title)    if not hwnd: return    # find child button    h_btn = win32gui.FindWindowEx(hwnd, None,"Button", None)    if not h_btn: return    # show text    text = win32gui.GetWindowText(h_btn)    print(text)    # click button            win32gui.PostMessage(h_btn, win32con.WM_LBUTTONDOWN, None, None)    time.sleep(0.2)    win32gui.PostMessage(h_btn, win32con.WM_LBUTTONUP, None, None)    time.sleep(0.2)

MsgBox "Message with default title.", vbInformation, MsgBox "Message with title My App 1", vbInformation, "My App 1"MsgBox "Message with title My App 2", vbInformation, "My App 2"

def _close_msgbox(self):    """Click any button ("OK", "Yes" or "Confirm") to close message box."""    # get handles of all top windows    h_windows = []    win32gui.EnumWindows(lambda hWnd, param: param.append(hWnd), h_windows)     # check each window        for h_window in h_windows:                    # get child button with text OK, Yes or Confirm of given window        h_btn = win32gui.FindWindowEx(h_window, None,"Button", None)        if not h_btn: continue        # check button text        text = win32gui.GetWindowText(h_btn)        if not text.lower() in ("ok", "yes", "confirm"): continue        # click button        win32gui.PostMessage(h_btn, win32con.WM_LBUTTONDOWN, None, None)        time.sleep(0.2)        win32gui.PostMessage(h_btn, win32con.WM_LBUTTONUP, None, None)        time.sleep(0.2)