[Tutor] run excel macro from python

2011-11-15 Thread Pirritano, Matthew
Pythonistas, I am running an excel macro from python with the following code: The problem I'm having is that when I try to run this function I get a dialog window that pops up titled: "Update Values: Personal.xls" When I try to cancel out of it I get directed to a type mismatch in the excel

Re: [Tutor] string formatting

2011-09-19 Thread Pirritano, Matthew
Pythonistas, This is the resolution of a question I asked over the weekend. The method I was thinking of was in a program I wrote on my work computer but couldn't remember. Now I'm at work and I see. It is not including the tuple at the end of the string nor using a dictionary. There is another

[Tutor] copy and paste excel worksheet using win32

2011-07-13 Thread Pirritano, Matthew
Pythonistas, I have a nicely formatted report in excel that is designed to be filled in by an excel macro. But first I need to get the report worksheet into 52 separate excel workbooks. Here's what I've tried so far. I'm snipping the code a bit. I have a wx dialog that gets a directory where the

Re: [Tutor] creating distribution lists in outlook

2010-05-13 Thread Pirritano, Matthew
Thanks for all of the feedback. The work continues. Unfortunately I think the admin interface is only for internal lists, not emails outside the server. Thanks matt Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 --

Re: [Tutor] creating distribution lists in outlook

2010-05-13 Thread Pirritano, Matthew
ty Health Care Agency (714) 568-5648 -Original Message- From: Luke Paireepinart [mailto:rabidpoob...@gmail.com] Sent: Wednesday, May 12, 2010 5:00 PM To: Pirritano, Matthew Cc: tutor@python.org Subject: Re: [Tutor] creating distribution lists in outlook On Wed, May 12, 2010 at 6:32 PM, Pirr

Re: [Tutor] creating distribution lists in outlook

2010-05-12 Thread Pirritano, Matthew
t still takes a while. Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 -Original Message- From: Luke Paireepinart [mailto:rabidpoob...@gmail.com] Sent: Wednesday, May 12, 2010 4:26 PM To: Pirritano, Ma

Re: [Tutor] creating distribution lists in outlook

2010-05-12 Thread Pirritano, Matthew
ch Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 -Original Message- From: Luke Paireepinart [mailto:rabidpoob...@gmail.com] Sent: Wednesday, May 12, 2010 4:16 PM To: Pirritano, Matthew Cc: tutor@python.org Subject: Re: [Tutor] creating distribu

[Tutor] creating distribution lists in outlook

2010-05-12 Thread Pirritano, Matthew
Pythonistas, I'm trying to find a way to get data into outlook. Specifically to create distribution lists. I need to create a number of distribution lists on a regular basis. Each list is created from one long master list. I will step through the master list 50 lines at a time, save as separat

Re: [Tutor] getting a wx.gauge to close!

2009-12-31 Thread Pirritano, Matthew
op() Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5648 -----Original Message- From: tutor-bounces+mpirritano=ochca@python.org [mailto:tutor-bounces+mpirritano=ochca@python.org] On Behalf Of Alan Gauld

[Tutor] getting a wx.gauge to close!

2009-12-30 Thread Pirritano, Matthew
Pythonistas, I have got a wx.gauge running and I cannot get it to go away! Any quick and dirty ideas or do you need my ugly syntax. I'm a newbie! Thanks Matt Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (714) 568-5

Re: [Tutor] why is unicode converted file double spaced?

2009-04-08 Thread Pirritano, Matthew
Excellent! Thanks! After specifying the output encoding as cp1252 I ran this short syntax and got zero errors. Thanks to Jon Peck from the SPSS list who also weighed in. Thanks matt Matthew Pirritano, Ph.D. Research Analyst IV Medical Services Initiative (MSI) Orange County Health Care Agency (

Re: [Tutor] why is unicode converted file double spaced?

2009-04-07 Thread Pirritano, Matthew
___ From: tutor-bounces+mpirritano=ochca@python.org [mailto:tutor-bounces+mpirritano=ochca@python.org] On Behalf Of Marc Tompkins Sent: Tuesday, April 07, 2009 11:05 AM To: tutor@python.org Subject: Re: [Tutor] why is unicode converted file double spaced? On Tue, Apr 7, 2009 at 10:57 AM, Pi

Re: [Tutor] why is unicode converted file double spaced?

2009-04-07 Thread Pirritano, Matthew
:26 AM, Pirritano, Matthew wrote: Thanks Marc, But I think that got rid of all of my carriage returns. Everything on just one line now. Sorry! My bad! Try this instead: for outLine in inp: outp.write(outLine.strip() + '\n') ___

Re: [Tutor] why is unicode converted file double spaced?

2009-04-07 Thread Pirritano, Matthew
+mpirritano=ochca@python.org [mailto:tutor-bounces+mpirritano=ochca@python.org] On Behalf Of Marc Tompkins Sent: Tuesday, April 07, 2009 10:12 AM To: tutor@python.org Subject: Re: [Tutor] why is unicode converted file double spaced? On Tue, Apr 7, 2009 at 9:52 AM, Pirritano, Matthew wrote

[Tutor] why is unicode converted file double spaced?

2009-04-07 Thread Pirritano, Matthew
So Kent's syntax worked to convert my Unicode file to plain text. But now my data is double space. How can I fix this. Here is the code I'm using. import codecs inp = codecs.open('g:\\data\\amm\\text files\\test20090320.txt', 'r', 'utf-16') outp = open('g:\\data\\amm\\text files\\new_text_file.t

Re: [Tutor] unicode to plain text conversion

2009-04-07 Thread Pirritano, Matthew
unces+mpirritano=ochca@python.org [mailto:tutor-bounces+mpirritano=ochca@python.org] On Behalf Of Kent Johnson Sent: Monday, April 06, 2009 5:51 PM To: Pirritano, Matthew Cc: Python Tutor Subject: Re: [Tutor] unicode to plain text conversion On Mon, Apr 6, 2009 at 6:48 PM, Pirritano, Matthew

Re: [Tutor] unicode to plain text conversion

2009-04-07 Thread Pirritano, Matthew
hca@python.org [mailto:tutor-bounces+mpirritano=ochca@python.org] On Behalf Of Alan Gauld Sent: Tuesday, April 07, 2009 1:42 AM To: tutor@python.org Subject: Re: [Tutor] unicode to plain text conversion "Pirritano, Matthew" wrote > I am a total newbie. I have a very large file >

Re: [Tutor] unicode to plain text conversion

2009-04-06 Thread Pirritano, Matthew
ilto:wes...@gmail.com] Sent: Monday, April 06, 2009 4:40 PM To: Pirritano, Matthew Cc: Python Tutor Subject: Re: [Tutor] unicode to plain text conversion > I am a total newbie. I have a very large file > 4GB that I need to > convert from Unicode to plain text. I used to just use dos when the

[Tutor] unicode to plain text conversion

2009-04-06 Thread Pirritano, Matthew
Hello python people, I am a total newbie. I have a very large file > 4GB that I need to convert from Unicode to plain text. I used to just use dos when the file was < 4GB but it no longer seems to work. Can anyone point me to some python code that might perform this function? Thanks Matt Matthew