Thanks for your help ... That does the trick.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Roberts
Sent: Monday, February 06, 2006 10:27 AM
To: [email protected]
Subject: Re: [python-win32] Visual Basic
Speers, Ted wrote:
>Maybe I should have just asked how to deal with this first.
>
>xlapp=win32com.client.Dispatch("Excel.Application")
>book=xlapp.Workbooks("bookname")
>VBProj=book.VBProject
>
>...
>com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft Office
>Excel', 'Programmatic access to Visual Basic Project is not trusted\n',
>'C:\\Program Files\\Microsoft Office\\OFFICE11\\1033\\xlmain11.chm', 0,
>-2146827284), None)
>
>
>It appears to me that I need to sign my Project for Python will let me
see it ... is there a workaround?
>
>
Googling the message brought me to an MSDN page that discusses this. If
you go to Tools, Macros, Security, you should be able to check a box
saying to "trust access to Visual Basic project".
--
Tim Roberts, [EMAIL PROTECTED]
Providenza & Boekelheide, Inc.
_______________________________________________
Python-win32 mailing list
[email protected]
http://mail.python.org/mailman/listinfo/python-win32
This information contained or attached to this e-mail may be subject to the
Export Administration Regulations (EAR) or the International Traffic in Arms
Regulations (ITAR) and may require an approved export license prior to its
export. An export can include a release or disclosure to a foreign national
inside or outside the United States. Include this notice with any reproduced
portion of this information.
_______________________________________________
Python-win32 mailing list
[email protected]
http://mail.python.org/mailman/listinfo/python-win32
