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 sho
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 ac
___
From: [EMAIL PROTECTED] on behalf of Tim Roberts
Sent: Mon 2/6/2006 9:06 AM
To: [email protected]
Subject: Re: [python-win32] Visual Basic
On Sun, 5 Feb 2006 16:18:51 -0800, "Speers, Ted" <[EMAIL PROTECTED]>
wrote:
>I'd like to redo al
Speers, Ted wrote:
>
>- -All of my VBA code is "within Excel." Sorry for the confusion. I don't
>know any better.
>
>
I wondered about that, and I probably should have clarified it before I
responded. VBA forms are just Excel objects, and should be able to be
manipulated using the Excel ob
>If I can do this I'll be golden:
>
>Imagine an Excel Macro Start that does the following:
>
>Sub Start():
>Set form = MyUserForm
>load form
>form.show vbmodeless
>
>end sub
>
>
Yes, but you can't really do that from Excel either, can you? If
MyUserForm is a VBA form within
On Sun, 5 Feb 2006 16:18:51 -0800, "Speers, Ted" <[EMAIL PROTECTED]>
wrote:
>I'd like to redo all my Visual Basic Projects in Python ... I would
>have started down the Python path from the get-go but was in too much of
>rush. Now that I have a moment, I thought I'd get the help I need.
>
>I kno
