[python-win32] help with pywin32

[Moll, Benjamin]

Hey guys,

Im working with this script since weeks. Until today everything works fine. I could open, read and modify cells without any problems. since this morning I receive an error that says:

 

Traceback (most recent call last):

  File "C:\Documents and Settings\USER\Desktop\Code\python\test_file.py", line 129, in <module>

    EX = excel_com(ROOT, module_name, TEST_CHAPTER, TEST_DESCRIPTION, Scope_defines)

  File "C:\Documents and Settings\USER\_resources\libs\excel_lib.py", line 88, in __init__

    self.xlApp.Workbooks.open(r'C:\Documents and Settings\USER\Testreport\FRT.xlsx')

  File "C:\Python31\Lib\site-packages\win32com\client\__init__.py", line 462, in __getattr__

    raise AttributeError("'%s' object has no attribute '%s'" % (repr(self), attr))

AttributeError: '<win32com.gen_py.Microsoft Excel 12.0 Object Library.Workbooks instance at 0x16287504>' object has no attribute 'open'

 

what happened?

whats wrong with my code:

 

self.xlApp = Dispatch('Excel.Application')

self.xlApp.Visible = 1

self.xlApp.Workbooks.open(r'C:\Documents and Settings\USER\Testreport\FRT.xlsx') #error here

 

pls help me!

 

-----------------------------------------------------------------

Mit freundlichen Grüßen / With kind regards

 

Benjamin Moll

 

________________________________________
Geschäftsführer/Managing Directors: Dr. Joji Murakami, Brendan Mc Kearney, Satoru Yamaguchi, Yoshihiro Kawase
Sitz/Seat: Langen, Hessen; Registergericht/Commercial Register: Offenbach/Main HRB 32725
________________________________________
This e-mail and any attachment contains information
which is private and confidential and is intended
for the addressee only. If you are not an addressee,
you are not authorised to read, copy or use the e-mail
or any attachment. If you have received this e-mail
in error, please notify the sender by return e-mail
and then delete it.
________________________________________
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20091215/c47a4c54/attachment-0001.htm>