I'll give that a shot tomorrow when I work on the script some more. Thanks for the note on 'file'... none of the IDE's I've used have colored or yelled at me, so I just assumed it was free for the taking.. (used to VS where it yells at you for more then I'd care)
I've just started using SPE though... I'm very impressed with it compared to some of the others of tried which either just weren't quite ready for retail or to much like a plain text editor for my liking. Unless something comes up that I can't get working right, I'll be pitching the author a few bucks for his work :] Thanks again for all the help. Hopefully one day I'll be able to contribute some back! On Wed, 2006-09-13 at 04:12 +0100, Alan Gauld wrote: > > I can get file.write("'%s',") % xlSht.Cells(row,1).Value > > to work.. > > file.write("'%s'," % xlSht.Cells(row,1).Value) > > Try that.... > > The string formatting must happen inside the parens. > > > BTW using 'file' as a variab;e is not good since file is a > built-in function name (albeit an alias for open) and could > confuse a reader.. > > > Alan G. > _______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor