dan_roman wrote: > Hi, > I developed a script with a nice interface in Tkinter that allows me to > edit some formulas and to generate an Excel worksheet with VBA macros > within it. The script runs perfectlly in Office 2000, but in Office > 2003 crash at line: "wbc = workbook.VBProject.VBComponents.Add(1)" > Please help me :-( > > the code of the module that crash is (only in Excel 2003, in 2000 not): > > import os > import string > from win32com.client import Dispatch, constants > > str_code=""" > Dim nrfunc As Integer > Dim cursor As Integer > Dim i As Integer > Dim j As Integer > > > > Sub Fill() > > > 'Aflu numaru de functii din XL > i = 1 > .................. > """ > def createExcelReport(projectName,templateName,saveToPath): > # acquire application object, which may start application > application = Dispatch("Excel.Application") > > # create new file ('Workbook' in Excel-vocabulary) using the specified > template > workbook = application.Workbooks.Add("Template1.xls") > > # store default worksheet object so we can delete it later > defaultWorksheet = workbook.Worksheets(1) > > worksheet1 = workbook.Worksheets(1) > worksheet2 = workbook.Worksheets(2) > worksheet3 = workbook.Worksheets(3) > > ---->>>>> wbc = workbook.VBProject.VBComponents.Add(1) <<<<------ here > is the problem > > wbc.Name="Module1" > > wbc.CodeModule.AddFromString(str_code) > > path=saveToPath+"\\"+projectName+"_"+templateName+".xls" > > workbook.SaveAs(path) > > worksheet1 = workbook.Worksheets(1) > > # make stuff visible now. > worksheet1.Activate() > application.Visible = True >
Crash as in Office or as a Python exception ? -- http://mail.python.org/mailman/listinfo/python-list