[python-win32] Visual Basic

[Speers, Ted]

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 know how to connect to Excel:
win32com.client.Dispatch("Excel.Application").
 
How do I connect to a VisualBasic project?
 
I need more help than that though.
 
I can run a *.py script from a Visual Basic application but I'm not
quite sure how to keep running so I don't lose the objects and variables
I populate the first time I run the program ... I need to run additional
programs using that data.
 
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
    <run the Python module described below>
end sub
 
 
Imagine userform "MyUserForm" with two CommandButtons ... "init" and
"getdouble" and a TextBox "result"
 
My VisualBasic UserFormModule would have the following (pseudo)code:
 
sub init_click()
    initval=inputbox("enter the initialization value")
    <run the function init(initval) in the aforementioned Python module>
end
 
sub double_click()
   <run the function doubleval() in the aforementioned Python module>
end
 
A python module that would work for me would be:
 
import win32com.client
XLApp=win32com.client.Dispatch( "Excel.Application")
VBProj =win32com.client. Dispatch( ?)
 
class XLProj:
    def __init(self)__:
        self.val=None
 
def init(initval):
    MyProj.val=initval
 
def doubleval():
    VPProj.MyUserForm.Controls("result").Value=MyProj.val*2
 
MyProj=XLProj()
 


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20060205/c34d3266/attachment.html