Moll, Benjamin wrote:
>
> 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
>
"Open" needs to be capitalized. "Open", not "open".
--
Tim Roberts, t...@probo.com
Providenza & Boekelheide, Inc.
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32
