How to call Excel VBA functions and subs using Python win32com?

Question

My Excel workbook contains VBA subs and macros similar to those below; they sit in Module1.

How to call them using Python win32com module?

Public Sub setA1(ByVal s As String)
    ThisWorkbook.ActiveSheet.Range("A1").Value = s
End Sub

Public Function getA1() As String
    getA1 = ThisWorkbook.ActiveSheet.Range("A1").Value
End Function

Many thanks in advance!

This might help you : stackoverflow.com/questions/345920/… — Eric
– Eric, Commented Feb 6, 2013 at 15:27

Yulia V · Accepted Answer · 2013-02-06 15:38:10Z

15

import win32com.client
xl=win32com.client.Dispatch("Excel.Application")
xl.Workbooks.Open(Filename="c:\\temp\\book1.xls",ReadOnly=1)
xl.Application.Run("setA1", '4')
res = xl.Application.Run("getA1")
print res
xl = 0

Just as simple as this ....

answered Feb 6, 2013 at 15:38

Yulia V

3,56710 gold badges35 silver badges67 bronze badges

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

1 Comment

ilya Over a year ago

does it still work in 2022?

Collectives™ on Stack Overflow

How to call Excel VBA functions and subs using Python win32com?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related