How to create Excel or Windows Msg Box using COM in Python?

Question

Is there a way to get pywin32 to generate a VBA-style MsgBox in Excel, if not, perhaps the Windows equivalent?

I tried:

from win32com.client import Dispatch
excel = Dispatch('Excel.Application')
excel.MsgBox('foo')

but it gives the error below:

AttributeError: Excel.Application.MsgBox

For future reference saying what the error is could be helpful. — Aleksander Lidtke
– Aleksander Lidtke, Commented Oct 3, 2013 at 13:53
Sorry, It's COM, so it gives a generic error: AttributeError: Excel.Application.MsgBox — TimY
– TimY, Commented Oct 3, 2013 at 13:55

TimY · Accepted Answer · 2013-10-03 14:11:12Z

3

Hi you can use win32api:

import win32api

from win32con import MB_SYSTEMMODAL

response = win32api.MessageBox(0, "Did you hear the Buzzer?", "Buzzer Test", 4, MB_SYSTEMMODAL)

MB_SYSTEMMODAL is used for telling the system to show a message above all other applications.

TimY

5,4566 gold badges47 silver badges58 bronze badges

answered Oct 3, 2013 at 13:52

Kobi K

7,9376 gold badges47 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1