Swapping VBA code for python

Question

Morning,

I have a very simple VBA code which refreshers the addin i have in excel. This is below

Sub Refresh()
    ExecuteExcel4Macro "FDSFORCERECALC(False)"

    ActiveWorkbook.Save

    ActiveWorkbook.Close

End Sub

I have tried using xlsxwriter but i am unable to write anything but a macro to press which still means manually opening each file. Is there a way to automate this code into Python, so i can just iterate through files and refresh as I go?

Thanks

user325117 · Accepted Answer · 2016-03-19 12:07:48Z

2

You could use the pywin32 module's COM support to manipulate the files programmatically. It will look something like this:

import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
workBook = xlApp.Workbooks.Open("spreadsheet.xls")
xlApp.ExecuteExcel4Macro("FDSFORCERECALC(False)")
workBook.Save()
workBook.Close()
xlApp.Quit()

answered Mar 19, 2016 at 12:07

user325117

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

Collectives™ on Stack Overflow

Swapping VBA code for python

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