[python-win32] Executing eval function in VBscript
Janakiraman Mohanakrishnan
janakiraman.mohanakrishnan at tcs.com
Tue Feb 5 06:48:29 CET 2008
yes i want to have python functionality in excel,
iam trying to call python functions from VBscript,
more like evaluating a python expression say dictionary or list in
VBscript
For evaluating a python expression , python has some library functions
like eval which takes python expressions
in string format and checks whether it is a valid python expression or
not
so i thought of calling that python eval function in VBscript and validate
my datas
but the problem is when i tried to pass dictionaries for eg,
"{'key':value}" this is the format of dictionary in python
VBscript throws error like type mismatch
since VB dictionary representation of VB and python are different
Thanks and Regards!
"Tony Cappellini" <cappy2112 at gmail.com>
02/05/2008 01:51 AM
Please respond to
cappy2112 at gmail.com
To
python-win32 at python.org
cc
bgailer at alum.rpi.edu, janakiraman.mohanakrishnan at tcs.com
Subject
[python-win32] Executing eval function in VBscript
Date: Mon, 04 Feb 2008 10:05:11 -0500
From: bob gailer <bgailer at alum.rpi.edu>
Subject: Re: [python-win32] Executing eval function in VBscript
To: Janakiraman Mohanakrishnan <janakiraman.mohanakrishnan at tcs.com>
Cc: python-win32 at python.org
Message-ID: <47A729A7.5030709 at alum.rpi.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>>That's hard to answer until we know what you want to accomplish! Tell us
>>more. What problem are you trying to solve?
I think he wants to have python functionality from excel, which is
what I'd like to accomplish as well.
(Python embedded into excel, as opposed to launching Excel from Python)
>>Also I'm not very familiar with MSScriptControl. I googled it and found
>>no useful documentation. Do you have any references to it?
Everything you want to know about the MSScriptControl is on microsoft's
site.
ForwardSourceID:NT0000976E
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/python-win32/attachments/20080205/b906b931/attachment.htm
More information about the python-win32
mailing list