python and macro excel

Harald Massa cpl.19.ghum at spamgourmet.com
Fri Apr 18 06:26:41 EDT 2003


Hello Georges,

> i want to integrate a macro in excel with python and execute it 
you allways have to get the win32all extenstion


What exactly do you want to do?

a) write a vba makro and execute it from Python?
o = win32com.client.Dispatch("Excel.Application")
o.Visible = 1
o.Workbooks.Add() # Double Check the actual code, changes sometimes

o.Run("NameOfYourMakro)

b) write a Python Program and execute it from VBA?
recommendation: build a COM-Server in Python, use it from VBA. More 
difficult. 

Harald




More information about the Python-list mailing list