[python-win32] Python and Excel

[Jd H]

Hi there,

I have the below python code that was working via
Windows Task Scheduler on Windows 2000 Terminal
Server:

import os, commands
from win32com.client import Dispatch

myExcel.Workbooks.Add('C:/JD/billing/Billing-Report-'
+ str(today) + '.xls')
myExcel.Workbooks.Add('C:/JD/billing/macro.XLA')
myExcel.Run('Macro1')
myExcel.Application.DisplayAlerts = False
myExcel.ActiveWorkbook.SaveAs('C:/JD/billing/Billing-Report-'
+ str(today) + '.xls')
myExcel.Quit()

It was working perfectly well, until yesterday, the
task was completing with exit code (1). The code works
perfectly  if run from command line. Is it something
related to Windows security update yesterday? How to
get around this, please?

Thanks,
JD


      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping