[python-win32] Visual Basic

[Speers, Ted]

Thanks for your help ... That does the trick. 

-----Original Message-----
From: python-win32-bounces at python.org
[mailto:python-win32-bounces at python.org] On Behalf Of Tim Roberts
Sent: Monday, February 06, 2006 10:27 AM
To: python-win32 at python.org
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, timr at probo.com
Providenza & Boekelheide, Inc.

_______________________________________________
Python-win32 mailing list
Python-win32 at python.org
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.