Python crash when trying to generate an Excel worksheet with VBA macros
hg
hg at nospam.com
Wed Oct 4 13:57:24 EDT 2006
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 ?
More information about the Python-list
mailing list