Close excel without VBA alert in python

Question

I am using python win32com library to read an excel file. Following is the snippet I use.

import win32com.client

excel = win32com.client.Dispatch('Excel.Application')
workbook = excel.Workbooks.Open("path.xlsm")
s=workbook.Sheets('Request')
print(str(s.Cells(10,18)).replace(" ","").lower())
workbook.Close()

On calling close, a VBA warning pops up. And the program execution stops till I press'OK'. Please help me in ignoring this warning? I have tried excel.DisplayAlerts = False , which didn't help

braX · Accepted Answer · 2017-06-12 13:48:40Z

3

have you tried workbook.Close(False) ?

excel.EnableEvents = False will disable Excel Macros.

edited Jun 12, 2017 at 13:48

answered Jun 12, 2017 at 13:25

braX

11.9k5 gold badges24 silver badges38 bronze badges

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

7 Comments

braX Over a year ago

What exactly does the warning say?

Nithin Mohan Over a year ago

It is a custom warning user has put using VBA script. I cannot see the exact logic there. Basically, it is a reminder to save. The same can be seen when I close the excel manually. This warning won't come if I open with macros disabled using excel.

braX Over a year ago

Then why can you not simply remove that line of code?

braX Over a year ago

Why is that? That is the only way to get rid of the warning.

Nithin Mohan Over a year ago

Oh, is that so? Can I open excel with macros disabled? Thanks a lot for the help

|

biniow · Accepted Answer · 2017-06-12 13:28:03Z

0

You can cheat and set:

workbook.Saved = True

before closing workbook. Excel will treat it as it is already saved.

answered Jun 12, 2017 at 13:28

biniow

4012 silver badges10 bronze badges

1 Comment

biniow Over a year ago

So you have to probably set your path as Trusted Location. Excel -> File -> Options -> Trust Center -> Trust Center Settings -> Trusted Locations and add directory where your file path.xlsm is stored.

Collectives™ on Stack Overflow

Close excel without VBA alert in python

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related