Office COM automatisation - calling python from VBA

2009-07-23 Thread Dushku, Aaron - Amherst, MA
I'd like a copy of that code. Thanks for taking the time for all of us. Sincerely, Aaron Dushku ** Aaron Dushku GIS Specialist USDA-NRCS Amherst, Massachusetts (413) 253-4379 Email: aaron.dushku at ma.usda.gov -- http://mail.python.org/mailman/listinfo/python-li

Re: Office COM automatisation - calling python from VBA

2005-06-28 Thread guy lateur
Just an update: I've succeeded in writing a COM server, exposing wxPy funtcionality. I've also used this object from within Outlook - 2 lines of VBA: dispatch COM object & call method. If anyone is interested, I could post the source. A few days ago, I honestly didn't think I'd already be this

Re: Office COM automatisation - calling python from VBA

2005-06-27 Thread Guy Lateur
Thanks for the input, people! -- http://mail.python.org/mailman/listinfo/python-list

Re: Office COM automatisation - calling python from VBA

2005-06-25 Thread Johan Lindberg
Hi. > > If you are new to Python and want to use it with COM, definitely get > > yourself a copy of _Python Programming on Win32_ by Mark Hammond and > > Andy Robinson. > > ...or at least read the chapter available online: > http://www.oreilly.com/catalog/pythonwin32/chapter/ch12.html Also, check

Re: Office COM automatisation - calling python from VBA

2005-06-25 Thread Konstantin Veretennicov
On 6/25/05, Josef Meile <[EMAIL PROTECTED]> wrote: > You could try to do an addin/addon for Word, Excel, and Outlook. You > don't need to code with VBA. Here you just need a language from where > you can access the microsoft interop assemblies (ie: C++ or C#; > IronPython maybe?) Hmm... Why jump t

Re: Office COM automatisation - calling python from VBA

2005-06-25 Thread Josef Meile
Hi guy, > I'll be using COM, and I could probably make an application that > controls Outlook (externally). But I'd also like to have this > functionality exposed in OL itself. So I guess I'll need to use VBA, > but I don't really like VBA - relax, please, it's just an opinion.. ;) > > So, ideall

Re: Office COM automatisation - calling python from VBA

2005-06-25 Thread Konstantin Veretennicov
On 6/25/05, Stephen Prinster <[EMAIL PROTECTED]> wrote: > guy lateur wrote: > > If you are new to Python and want to use it with COM, definitely get > yourself a copy of _Python Programming on Win32_ by Mark Hammond and > Andy Robinson. ...or at least read the chapter available online: http://www

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread Stephen Prinster
guy lateur wrote: > So, ideally, I'd like to program as much as possible in python (I'm > pretty new to that, too, btw), and only use VBA if needed - say, to > call python objects/methods (+ wxGUI, please). > If you are new to Python and want to use it with COM, definitely get yourself a copy of

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread Chris Smith
> "guy" == guy lateur <[EMAIL PROTECTED]> writes: guy> Hi all, I am trying to write some code (macro's, if you like) guy> to glue together our Office applications (mainly Word, Excel guy> and Outlook). We have a lot of different projects going on guy> simultaneously. The idea i

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread guy lateur
> You want to use --- Python ??? So far I haven't been informed of any serious arguments as to why I wouldn't. > How, pray tell, do you add up (VBA+VBA+VBA+VBA+VBA) and have it come out > equaling Python? My total was this: 57*python + wxPython. > Do you think that might please a few of us

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread Thomas Bartkus
"guy lateur" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi all, > > I am trying to write some code (macro's, if you like) to glue together > our Office applications (mainly Word, Excel and Outlook). We have a lot > of different projects going on simultaneously. The idea is to dev

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread erinhouston
Can you make python into a com object? I think you can I just don't rember. If so you want to find a page about com add-ins for office. This is a com object that you can teach office to look for when It is started. I wrote one in vb years ago and havn't looked back. But I think that would be the

Re: Office COM automatisation - calling python from VBA

2005-06-24 Thread Do Re Mi chel La Si Do
Hi ! Perso, j'utilise ça (VBA) : Sub TestPonx() Dim oa As Object Set oa = CreateObject("Ponx.Mci") Cells(2, 4) = oa.PRet("123+45+6") Set oa = Nothing End Sub "Ponx.Mci" est le nom du serveur COM Python PRet() est équ

Office COM automatisation - calling python from VBA

2005-06-24 Thread guy lateur
Hi all, I am trying to write some code (macro's, if you like) to glue together our Office applications (mainly Word, Excel and Outlook). We have a lot of different projects going on simultaneously. The idea is to develop a centralized framework (starting point, common interface) for my users to vi