[python-win32] More VisualBasic

[Speers, Ted]

Thanks ... using VB widgets is not a requirement ... I was just lost when I tried to pick a GUI tool a year ago ... 
 
what would would float my boat would be some consensus about which is best ... wxPython, tkinter, something else ... or some decent write up describing the options 

________________________________

From: python-win32-bounces at python.org on behalf of Tim Roberts
Sent: Wed 2/8/2006 5:17 PM
To: python-win32 at python.org
Subject: Re: [python-win32] More VisualBasic



On Wed, 8 Feb 2006 11:28:16 -0800, "Speers, Ted" <Ted.Speers at actel.com>
wrote:

>I'm sure I'm destined to be a consumer of versus a contributor to this
>group's output.
> 
>

We all started out that way.

>I'd like to get some advice from the group whether I should pursue the
>road I'm on ...
>Am I on a fools errand trying to develop an application in Python that
>manipulates VBUserForms?  Are these errors that I'm seeing going to be
>the bane of my existence due to some inherent flakiness or, through
>experience/reading/discussiongroups/magic, will I be able to gain enough
>understanding of how things work so that I can consistently avoid these
>pitfalls?
> 
>

Here's my personal opinion, remembering that free advice is usually
worth exactly what you paid for it.   If you really need to be working
with VBA forms in Excel, you will just hurt yourself to try to control
them with anything other than VBA.

It is quite possible to control Excel from Python; you can feed
information into and out of cells in worksheets, and format it to your
heart's content.  It is quite possible to write a Python app with a UI,
using tkinter or wxPython or whatever floats your boat, and have the
events in that UI tickle Excel.  However, if the UI was done in VBA, and
must remain in VBA, then you probably want to manipulate the UI with
VBA.  Getting a VBA form to fire a Python event is difficult.

Don't think of VBA as part of Excel.  Think of it as a separate language
that happens to hook into the Excel object model.  That's exactly what
Python is.  Both of them can manipulate Excel, but it's a lot of work to
have one of them manipulate the other.

--
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.