Re: win32com.client .Cells

On Tue, Oct 13, 2015 at 1:37 AM, Michiel Overtoom wrote: > Hi, > >> excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') > > Shouldn't this be: > > excel_book=Excel.Workbooks.Open('D:\\WebPython\\Config3.xlsx') > or > excel_book=Excel.Workbooks.Open(r'D:\WebPython\Config3.xlsx') >

Re: win32com.client .Cells

Hi, > excel_book=Excel.Workbooks.Open('D:\WebPython\Config3.xlsx') Shouldn't this be: excel_book=Excel.Workbooks.Open('D:\\WebPython\\Config3.xlsx') or excel_book=Excel.Workbooks.Open(r'D:\WebPython\Config3.xlsx') ? -- https://mail.python.org/mailman/listinfo/python-list

Re: win32com.client .Cells

Very Thanks Irmen! It's helped me. -- https://mail.python.org/mailman/listinfo/python-list

Re: win32com.client .Cells

On 9-10-2015 20:45, gall.pavgal.g...@gmail.com wrote: > Hi Guys, > > i wrote small function : > > Excel = win32com.client.Dispatch("Excel.Application") [...] > com_error: (-2147221008, 'CoInitialize has not been called.', None, None) > > Please, help me! :) > First hit on google when search

Re: win32com.client import problem

Threader Slash wrote: Hi Everybody, I have 2 imports: import pythoncom from win32com.client import Dispatch if I run it on my Python 2.6 Console, it works nicely. However, when I go to Eclipse IDE, open a project, open a main.py file, and try run, it gives the error: import pythoncom ImportEr

Re: win32com.client / Trendlines

On Jan 28, 4:21 pm, mathieu wrote: > Hi there, > >   I am trying to use win32com.client, but I do not think I fully grasp > the concept. So far I copied chunk of code from the net to write my > script. It worked well until I could not find any example on > Trendlines. According to doc it should be

Re: win32com.client (Howto edit Contacts in Outlook)

"Tim Golden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bill Davy wrote: >> Traceback (most recent call last): >> File "H:/Personal/OutlookIF1/t2.py", line 18, in >> outlook = win32com.client.gencache.EnsureDispatch >> ("Outlook.Application") >> File "C:\Python25\Lib\s

Re: win32com.client (Howto edit Contacts in Outlook)

Bill Davy wrote: Traceback (most recent call last): File "H:/Personal/OutlookIF1/t2.py", line 18, in outlook = win32com.client.gencache.EnsureDispatch ("Outlook.Application") File "C:\Python25\Lib\site-packages\win32com\client\gencache.py", line 536, in EnsureDispatch mod = EnsureM

Re: win32com.client (Howto edit Contacts in Outlook)

"Tim Golden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bill Davy wrote: >> and since then have been busy with work, and my other job, and the >> garden. > > Aha! So you're English, are you? Looks like you're in the West Country. > Weather map suggests you're not short of rain

Re: win32com.client (Howto edit Contacts in Outlook)

Bill Davy wrote: and since then have been busy with work, and my other job, and the garden. Aha! So you're English, are you? Looks like you're in the West Country. Weather map suggests you're not short of rain over there :) Now I am back looking at this (and using WInUSB to talk to a Maxim 342

Re: win32com.client (Howto edit Contacts in Outlook)

"Tim Golden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bill Davy wrote: >> I'm not sure OL2003 can read news. I think perhaps some later OL can >> (added tot he View menu, perhaps?). So I use OL Express to read news. >> The OL with which I wish to communicate is: >> >> Appl

Re: win32com.client (Howto edit Contacts in Outlook)

Bill Davy wrote: I'm not sure OL2003 can read news. I think perhaps some later OL can (added tot he View menu, perhaps?). So I use OL Express to read news. The OL with which I wish to communicate is: Application name Outlook Version 11.0 Build 8217 Product ID 70141-700-0350904-56905 Languag

Re: win32com.client (Howto edit Contacts in Outlook)

"Tim Roberts" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Bill Davy" <[EMAIL PROTECTED]> wrote: >> >>I am trying to edit Contacts in Outlook. This is so I can transfer >>numbers >>from my address book which is an Excel spreadsheet to my mobile phone. > > Are you actually runni

Re: win32com.client (Howto edit Contacts in Outlook)

"Bill Davy" <[EMAIL PROTECTED]> wrote: > >I am trying to edit Contacts in Outlook. This is so I can transfer numbers >from my address book which is an Excel spreadsheet to my mobile phone. Are you actually running Outlook? Your news posting was made from Outlook Express, and Outlook Express can

Re: win32com.client (Howto edit Contacts in Outlook)

"Bill Davy" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > "Tim Golden" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] >> Bill Davy wrote: >>> I am trying to edit Contacts in Outlook. This is so I can transfer >>> numbers from my address book which is an Excel spre

Re: win32com.client (Howto edit Contacts in Outlook)

"Tim Golden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Bill Davy wrote: >> I am trying to edit Contacts in Outlook. This is so I can transfer >> numbers from my address book which is an Excel spreadsheet to my mobile >> phone. I came across the following snippet of code > >

Re: win32com.client (Howto edit Contacts in Outlook)

Bill Davy wrote: I am trying to edit Contacts in Outlook. This is so I can transfer numbers from my address book which is an Excel spreadsheet to my mobile phone. I came across the following snippet of code --- hey! that looks familiar :) which enabled me to the contacts at least list. I

Re: win32com.client question

On Feb 13, 8:05 am, Juan_Pablo <[EMAIL PROTECTED]> wrote: > import win32com.client > is posible in linux ? No. It's a Windows only Python extension. Mike -- http://mail.python.org/mailman/listinfo/python-list

Re: win32com.client question

On Feb 13, 2008 11:58 AM, James Matthews <[EMAIL PROTECTED]> wrote: > What do you mean possible? > It is possible to use the library win32com.client in linux? I thought that was only for windows ?¿ -- http://mail.python.org/mailman/listinfo/python-list

Re: win32com.client question

Juan_Pablo wrote: > import win32com.client > is posible in linux ? Not in any meaningful way. -- Gerhard -- http://mail.python.org/mailman/listinfo/python-list

Re: win32com.client question

What do you mean possible? On Feb 13, 2008 3:05 PM, Juan_Pablo <[EMAIL PROTECTED]> wrote: > import win32com.client > is posible in linux ? > -- > http://mail.python.org/mailman/listinfo/python-list > -- http://search.goldwatches.com/?Search=Movado+Watches http://www.jewelerslounge.com http:/

Re: win32com.client documentation?

Mark Morss <[EMAIL PROTECTED]> wrote: > >I want to be able to script the creation of Excel spreadsheets and >Word documents, interract with Access data bases, and so forth. Empirically, the best way to do this (for me, at least) is to Google for examples. There are a few simple rules to learn on

Re: win32com.client documentation?

"Colin J. Williams" <[EMAIL PROTECTED]> wrote: >Mark Morss wrote: >> I am a unix person, not new to Python, but new to Python programming >> on windows. Does anyone know where to find documentation on >> win32com.client? I have successfully installed this module and >> implemented some example co

Re: win32com.client documentation?

Mark Morss wrote: > I am a unix person, not new to Python, but new to Python programming > on windows. Does anyone know where to find documentation on > win32com.client? I have successfully installed this module and > implemented some example code. But a comprehensive explanation of the > object

Re: win32com.client documentation?

On Oct 24, 7:35 am, Mark Morss <[EMAIL PROTECTED]> wrote: > I am a unix person, not new to Python, but new to Python programming > on windows. Does anyone know where to find documentation on > win32com.client? I have successfully installed this module and > implemented some example code. But a c

Re: win32com.client documentation?

On Oct 24, 9:35 am, Mark Morss <[EMAIL PROTECTED]> wrote: > I am a unix person, not new to Python, but new to Python programming > on windows. Does anyone know where to find documentation on > win32com.client? I have successfully installed this module and > implemented some example code. But a c

Re: win32com.client Excel Color Porblem

Thanks a lot!! ici wrote: > My Excel Template :) + Rows > > # -*- encoding:utf-8 -*- > import win32com.client > > try: import psyco; psyco.full() > except ImportError: pass > > try: > app = win32com.client.Dispatch("Excel.Application.11") # Excel > 2003 > except com_error: > try: >

Re: win32com.client Excel Color Porblem

On May 3, 1:37 am, Ray <[EMAIL PROTECTED]> wrote: > Hi, > > I need to use cell's background color. > > when I record a macro from excel, it shows: > > Rows("7:7").Select > With Selection.Interior > .ColorIndex = 8 > .Pattern = xlSolid > > how do I run it from python win32com

Re: win32com.client

btw... the statement with "youtube" was a joke. I really applaud rzed you for giving this detailed descriptions, people like him make the spirit of c.l.p.: People get help here WAY over what commercial support usually gets you. Thanks for doing that, rzed! best wishes, HArald -- http://mail.p

Re: win32com.client

rzed, > 1) In your browser, enter this URL:http://sourceforge.net/projects/pywin32/ > [...] > Try those steps, then try importing win32com again. man, you are SO 2005. Could'nt you please make a screen cap video, upload it to youtube and give a pointer to it on your blog? *wink* Harald --

Re: win32com.client

"vithi" <[EMAIL PROTECTED]> wrote: >Hi, >I use python for window. If you are saying win32com in part of the >python then you are wrong. Look, you aren't paying attention. No one has said win32com is part of Python. What everyone has said is that win32com is part of the "Python for Windows extens

Re: win32com.client

"vithi" <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > Hi, > I use python for window. If you are saying win32com in part of the > python then you are wrong. That is not what I or anyone else is saying. What we have said, perhaps not in words you understand, is this: 1) In your browser

Re: win32com.client

En Thu, 01 Feb 2007 22:18:49 -0300, vithi <[EMAIL PROTECTED]> escribió: > If you are saying win32com in part of the python then you are wrong. Uh, what is so difficult to understand? vithi wrote: >> Any one tell me where I can get (or download) python modules win32com On Jan 31, 1:45 pm, Gary

Re: win32com.client

Hi, I use python for window. If you are saying win32com in part of the python then you are wrong. Here is a prove:- IDLE 1.2 >>> import win32com Traceback (most recent call last): File "", line 1, in import win32com ImportError: No module named win32com >>> you try in your computer

Re: win32com.client

On Jan 31, 6:35 pm, rzed <[EMAIL PROTECTED]> wrote: > "vithi" <[EMAIL PROTECTED]> wrote innews:[EMAIL PROTECTED]: > > > Hi > > Any one tell me where I can get (or download) python modules > > win32com or win32com.client because I have to use "Dispatch" > > thanks > > What distribution are you using

Re: win32com.client

Hi, If you are saying win32com in part of the python then you are wrong. Here is a prove:- IDLE 1.2 >>> import win32com Traceback (most recent call last): File "", line 1, in import win32com ImportError: No module named win32com >>> you try in your computer On Jan 31, 7:17 pm, "Gabrie

Re: win32com.client

En Wed, 31 Jan 2007 22:17:10 -0300, vithi <[EMAIL PROTECTED]> escribió: > This is not I was looking for. There is a module call > "win32com.client" in python some people used it If any body know about > it let me know. > > On Jan 31, 1:45 pm, Gary Herron <[EMAIL PROTECTED]> wrote: >> vithi wrote:

Re: win32com.client

"vithi" <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]: > Hi > Any one tell me where I can get (or download) python modules > win32com or win32com.client because I have to use "Dispatch" > thanks > What distribution are you using? If you are using Windows and have downloaded the Python.

Re: win32com.client

This is not I was looking for. There is a module call "win32com.client" in python some people used it If any body know about it let me know. On Jan 31, 1:45 pm, Gary Herron <[EMAIL PROTECTED]> wrote: > vithi wrote: > > Hi > > Any one tell me where I can get (or download) python modules win32com >

Re: win32com.client

vithi wrote: > Hi > Any one tell me where I can get (or download) python modules win32com > or win32com.client because I have to use "Dispatch" thanks > > You want the "python for windows" extension, available from http://sourceforge.net/projects/pywin32/ Gary Herron -- http://mail.python.

Re: win32com.client & OS X

> I'd like to know if it is possible to call the win32com.client > component using Python on MAC OS X (or maybe Linux) and, if so, how? OS X doesn't really do COM; it's mostly Apple events at the desktop level. See for a Python-AE bridge. If you want more detaile

Re: win32com.client problem

Thanks for the reply. I will chew on this a bit. "Kartic" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi, > > 1. Put your COM invokations in a try/except loop. From my experience, > that helped me prevent, in most cases, Excel from "hanging" and having > to restart the PC too. I

Re: win32com.client problem

Hi, 1. Put your COM invokations in a try/except loop. From my experience, that helped me prevent, in most cases, Excel from "hanging" and having to restart the PC too. In the except part, release the Excel (or other COM resource) (e.g.calling workbook.Close() or excelobj.Quit(), depending on the s