Can't save Excel file with win32com.client

Question

When I try to save the file, it doesn't save and fails.

I get the error:

pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft Excel', 'Save method of Application class failed', 'xlmain11.chm', 0, -2146827284), None)

Not sure what I'm doing wrong here. Some other posts seem to be pretty old and not relevant.

I saw a post saying to use SaveAs() but that errors out and says AttributeError: <unknown>.SaveAs. Did you mean: 'Save'?

My code:

import os, os.path
import win32com.client

# path = (r'C:\Users\christiansanchez\Downloads\')

if os.path.exists("test_macro.xlsm"):
    xl = win32com.client.Dispatch("Excel.Application")
    xl.Workbooks.Open(os.path.abspath("test_macro.xlsm"))
    xl.Application.Run("test_macro.xlsm!module1.test_macrob")
    xl.Application.Save("test_macro.xlsm")
    xl.Application.Quit("test_macro.xlsm")
else:
    print("error")

You want to call .Save on a Workbook object, not the Application. Btw, I don't think Quit has any parameters. — BigBen
– BigBen, Commented Feb 2, 2023 at 22:06
Also, xl.Application is superfluous. xl already refers to an Application object, just use xl.Workbooks.Open etc. — DS_London
– DS_London, Commented Feb 3, 2023 at 10:32

DS_London · Accepted Answer · 2023-02-03 10:41:24Z

3

As per the comments, assign a variable to the opened workbook, and call Save() on that:

import os, os.path
import win32com.client

# path = (r'C:\Users\christiansanchez\Downloads\')

if os.path.exists('test_macro.xlsm'):
    xl = win32com.client.Dispatch('Excel.Application')
    wb = xl.Workbooks.Open(os.path.abspath('test_macro.xlsm'))
    xl.Run('test_macrob')
    wb.Save()
    xl.Quit()
else:
    print("error")

Notes:

Macro names are at global scope in Excel, so unless you have two sheets with the same macro name open you don't need to fully qualify the macro name.
The variable xl already refers to an Application object: you don't need xl.Application

answered Feb 3, 2023 at 10:41

DS_London

4,3311 gold badge12 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Can't save Excel file with win32com.client

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related