<div>Bingo That Worked.</div>
<div> </div>
<div>Thanks,</div>
<div>Tim<br></div>
<div class="gmail_quote">On Mon, Mar 17, 2008 at 11:25 PM, <<a href="mailto:python-win32-request@python.org">python-win32-request@python.org</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Send python-win32 mailing list submissions to<br> <a href="mailto:python-win32@python.org">python-win32@python.org</a><br>
<br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="http://mail.python.org/mailman/listinfo/python-win32" target="_blank">http://mail.python.org/mailman/listinfo/python-win32</a><br>or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:python-win32-request@python.org">python-win32-request@python.org</a><br><br>You can reach the person managing the list at<br> <a href="mailto:python-win32-owner@python.org">python-win32-owner@python.org</a><br>
<br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of python-win32 digest..."<br><br><br>Today's Topics:<br><br> 1. Re: python-win32 Digest, Vol 60, Issue 26 (Tim Golden)<br>
2. Re: Skip Alt+F4 (le dahut)<br> 3. Re: Running SQL queries on excel sheets (Rickey, Kyle W)<br> 4. Re: How to create a com_record? (Kevin Patterson)<br> 5. Confusion with 'SetForegroundWindow() (Scott Nelson)<br>
6. python 2.5 (Tarun Kapoor)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Mon, 17 Mar 2008 11:51:01 +0000<br>From: Tim Golden <<a href="mailto:mail@timgolden.me.uk">mail@timgolden.me.uk</a>><br>
Subject: Re: [python-win32] python-win32 Digest, Vol 60, Issue 26<br>Cc: <a href="mailto:python-win32@python.org">python-win32@python.org</a><br>Message-ID: <<a href="mailto:47DE5B25.6070804@timgolden.me.uk">47DE5B25.6070804@timgolden.me.uk</a>><br>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>siddhartha veedaluru wrote:<br>> Hi Tim,<br>><br>> I tried the snippet you sent to me.<br>> Same error.<br>><br>> i opened the python shell and gave "import wmi"<br>
> It give the same error.<br>><br>> comobj._oleobj_.GetTypeInfo().GetContainingTypeLib()[0].GetTypeComp()<br>> com_error: (-2147319779, 'Library not registered.', None, None)<br><br>Aha. That's what I wanted to know. (In fact, now I look<br>
at your original post, the same information's shown there.<br>Shame on me for not checking).<br><br>It *looks* as though one (or more) of the WMI DLLs which in<br>my system are in c:\windows\system32\wbem need to be reregistered.<br>
It might be something else, however. Can you try running<br><br>regsvr32.exe against the DLLs in (your equivalent of)<br>c:\windows\system32\wbem?<br><br>I'm sorry this is so involved: I've never encountered someone<br>
with this error before when running WMI.<br><br>TJG<br><br><br>------------------------------<br><br>Message: 2<br>Date: Mon, 17 Mar 2008 14:11:14 +0100<br>From: le dahut <<a href="mailto:le.dahut@laposte.net">le.dahut@laposte.net</a>><br>
Subject: Re: [python-win32] Skip Alt+F4<br>To: Paul Moore <<a href="mailto:p.f.moore@gmail.com">p.f.moore@gmail.com</a>><br>Cc: Python-Win32 List <<a href="mailto:python-win32@python.org">python-win32@python.org</a>><br>
Message-ID: <<a href="mailto:47DE6DF2.6050108@laposte.net">47DE6DF2.6050108@laposte.net</a>><br>Content-Type: text/plain; charset=ISO-8859-1; format=flowed<br><br>Oh yes ! That's it. Thank you.<br><br>It is a frame that's used by a service to display some information<br>
before uncancelable forced reboot.<br><br>I now have to determinate how to modify the informations displayed in<br>the frame.<br><br>Should my program run in the class of the frame ? Or should it get a<br>sort of handler to the frame and modify the content of a text box ?<br>
I don't know if the second way is possible.<br><br>Paul Moore a ?crit :<br>> On 17/03/2008, le dahut <<a href="mailto:le.dahut@laposte.net">le.dahut@laposte.net</a>> wrote:<br>>> I'm writting a Wx app and I want to skip Alt+F4. I've used somehting<br>
>> like that :<br>>> def OnKeyDown(self, event):<br>>> print event.AltDown(), event.GetKeyCode()<br>>> if event.AltDown() and event.GetKeyCode() == wx.WXK_F4:<br>>> print 'try to close'<br>
>><br>>> Everything gets printed but my app closes anyway on Alt+F4, is there a<br>>> way to skip this ?<br>><br>> (a) you should think hard before doing this - about the only<br>> reasonable reason for overriding the standard Alt-F4 on Windows, is to<br>
> minimise to the tray rather than closing<br>><br>> (b) if you still want to do this, look at the OnClose event, and override that.<br>><br>> Paul.<br>><br>><br><br><br>------------------------------<br>
<br>Message: 3<br>Date: Mon, 17 Mar 2008 08:40:45 -0500<br>From: "Rickey, Kyle W" <<a href="mailto:Kyle.Rickey@bakerhughes.com">Kyle.Rickey@bakerhughes.com</a>><br>Subject: Re: [python-win32] Running SQL queries on excel sheets<br>
To: <<a href="mailto:python-win32@python.org">python-win32@python.org</a>><br>Message-ID:<br> <<a href="mailto:E369D273B0E6904EA8D4A952BA05953C07DD323B@MSGCLAMBX.ent.bhicorp.com">E369D273B0E6904EA8D4A952BA05953C07DD323B@MSGCLAMBX.ent.bhicorp.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br><br>Thanks John, I'll check that out.<br><br>-Kyle Rickey<br><br>-----Original Message-----<br>From: John Machin [mailto:<a href="mailto:sjmachin@lexicon.net">sjmachin@lexicon.net</a>]<br>
Sent: Sunday, March 16, 2008 4:40 AM<br>To: Rickey, Kyle W<br>Cc: <a href="mailto:python-win32@python.org">python-win32@python.org</a><br>Subject: Re: [python-win32] Running SQL queries on excel sheets<br><br>Rickey, Kyle W wrote:<br>
> Tim, thanks for your response. I've got 7 excel files that need<br>reading<br>> containing a total of ~6100 rows. I agree, about this code making me<br>> sick :)<br><br>That's not exactly "absolutely tons of data" :-)<br>
<br>One problem with the ODBC approach to reading spreadsheets (at least<br>with the MS Excel ODBC driver) is that it examines a limited number<br>(e.g. 8 or 10) of rows to determine what type a column is. So the first<br>
10 rows have floats in column X then Noddy's managed to get some text in<br><br>cell X11 which is a fatal error for ODBC -- you can't continue.<br><br>[snip]<br><br>> Obviously, all that is only helpful up to a point. Is there some<br>
> reason why you can't just pull the data out straight into Python<br>> structures and take it from there (or even push it into a Sqlite<br>> memory database)? Perhaps you've got absolutely tons of data so<br>
> extracting it would be a pain? If not, consider using one of<br>> the COM packages (win32com.client or comtypes) or something like<br>> pyExcelerator to pull it out.<br>> </more helpful><br><br>Consider the xlrd package (<a href="http://www.lexicon.net/sjmachin/xlrd.htm" target="_blank">http://www.lexicon.net/sjmachin/xlrd.htm</a>).<br>
It'll tell you what type the data is cell-by-cell -- you can then<br>compare that with your expectations.<br><br>HTH,<br>John<br><br><br><br><br>------------------------------<br><br>Message: 4<br>Date: Mon, 17 Mar 2008 12:18:26 -0400<br>
From: "Kevin Patterson" <<a href="mailto:patter001@gmail.com">patter001@gmail.com</a>><br>Subject: Re: [python-win32] How to create a com_record?<br>To: <a href="mailto:mhammond@skippinet.com.au">mhammond@skippinet.com.au</a><br>
Cc: Python-Win32 List <<a href="mailto:python-win32@python.org">python-win32@python.org</a>><br>Message-ID:<br> <<a href="mailto:a41467040803170918t5071e46bq160cb0e164b2d256@mail.gmail.com">a41467040803170918t5071e46bq160cb0e164b2d256@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>In case it helps, here's the overall description of the COM/app and what how<br>this function fits: "COM_App" is a typelib (with multiple classes) for<br>
interfacing to an application that controls hardware on a USB port. When<br>multiple applications are started it becomes impossible for users to write<br>code for accessing a particular instance of the app, therefore a manager com<br>
"COM_Manager" was created. There are two important level of the COM_Manager.<br>The first call gets you an object representing the particular application<br>(Its not really "COM_App" per-se, its just another object that handles that<br>
app). Then there is "SomeFunction" below, it gives you the particular class<br>for the particular COM_App. That is why it is takes a GUID as a parameter.<br><br>I'm still learning about the details of the COM, I guess VT_RECORD is sort<br>
of the standard way of passing any structure information back and forth? My<br>email access for the first half of the week is fairly limited but I'll still<br>try to learn my way around the test harness to see if I can create an<br>
example.<br><br>On Sat, Mar 15, 2008 at 12:54 PM, Mark Hammond <<a href="mailto:skippy.hammond@gmail.com">skippy.hammond@gmail.com</a>><br>wrote:<br><br>> Just to clarify:<br>><br>> > HRESULT SomeFunction( [in] GUID* pGuid, [out, retval,<br>
> iid_is(pGuid)]<br>> IUnknown** ppUnknown);<br>><br>> > win32com says that it needs a VT_RECORD in order to pass the GUID<br>> information<br>> > to the COM. But from previous email exchanges I can't just deifne some<br>
> GUID<br>><br>> My understanding is that the IDispatch implementation of this method<br>> declares that it wants a VT_RECORD - which win32com is trying to comply<br>> with.<br>><br>> When I get back home, my approach will be to simply try and repro the<br>
> issue<br>> in the win32com test suite, which will at least give me a clearer picture<br>> of<br>> what is happening. If Kevin could take some steps towards this it would<br>> help.<br>><br>> Cheers,<br>
><br>> Mark<br>><br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://mail.python.org/pipermail/python-win32/attachments/20080317/a1a03bc2/attachment-0001.htm" target="_blank">http://mail.python.org/pipermail/python-win32/attachments/20080317/a1a03bc2/attachment-0001.htm</a><br>
<br>------------------------------<br><br>Message: 5<br>Date: Mon, 17 Mar 2008 12:09:32 -0500<br>From: "Scott Nelson" <<a href="mailto:sirgnip@gmail.com">sirgnip@gmail.com</a>><br>Subject: [python-win32] Confusion with 'SetForegroundWindow()<br>
To: <a href="mailto:python-win32@python.org">python-win32@python.org</a><br>Message-ID:<br> <<a href="mailto:2682ac9b0803171009h25213a3bsbd55b93760bbf988@mail.gmail.com">2682ac9b0803171009h25213a3bsbd55b93760bbf988@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br><br>Greets...<br><br>I'm looking to use the win32api and win32gui modules to do a bit of<br>Windows tinkering (win2k, ActiveState's Python 2.4.1 distribution) and<br>
I've hit a snag.<br><br>I'd like to have my process/window "steal" the focus from whatever<br>window currently has it, get a bit of input from the keyboard, and<br>then restore the focus back to the original window.<br>
<br>In simple cases win32gui.SetForegroundWindow(hwnd) seems to be what<br>I'm looking for. It works fine when I simply try to set focus to<br>another window from my app.<br><br>But, I'm seeing unexpected behavior when I go beyond that. I wrote a<br>
simple test script that enumerates through all visible windows and<br>tries to give each one the focus in turn, after a short delay. It<br>gets through 1-2 windows out of the 8-10 non-minimized windows I have<br>open (IE, notepad, wordpad, etc.) and then gives me this:<br>
<br>Traceback (most recent call last):<br> File "D:\_code\python\apps\WinTests.py", line 25, in ?<br> cycle_foreground()<br> File "D:\_code\python\apps\WinTests.py", line 20, in cycle_foreground<br> win32gui.SetForegroundWindow(handle)<br>
pywintypes.error: (0, 'SetForegroundWindow', 'No error message is available')<br><br>What am I doing wrong in this case? Do I have some bad assumptions?<br>Is my app allowed to "give away" its focus but can't force a different<br>
app's window with focus to "give away" its focus? Is there any other<br>way to accomplish this? I've attempted using a mix of SetFocus(),<br>BringWindowToTop(), and EnableWindow() but couldn't find a magic<br>
combo.<br><br>I've attached my test script. Run it as "WinTests cycle" to attempt<br>to cycle the focus through all top level windows and see the<br>traceback. Run it as "WinTests 12345" to successfully set the focus<br>
to the window with hwnd of 12345. Run it as "WinTests" to get a list<br>of all top level window names and their hwnd's.<br><br>I've tried reading the win32 docs provided with ActiveState's<br>PythonWin, I've read a bit on the win32 API on MSDN and I've googled<br>
around a bit, and haven't found much.<br><br>So, I got curious and tried to code up something similar in C++. It<br>uses the identical API calls (from what I can tell) and It seems to<br>have no problem cycling through all the top-level windows. I've<br>
attached my .cpp file as well.<br><br>Why the discrepancy between what I'm seeing with win32gui and c++? Thoughts?<br><br>-Scott<br>-------------- next part --------------<br>An embedded and charset-unspecified text was scrubbed...<br>
Name: SetForegroundWindow.cpp<br>Url: <a href="http://mail.python.org/pipermail/python-win32/attachments/20080317/b29565b5/attachment-0002.txt" target="_blank">http://mail.python.org/pipermail/python-win32/attachments/20080317/b29565b5/attachment-0002.txt</a><br>
-------------- next part --------------<br>An embedded and charset-unspecified text was scrubbed...<br>Name: WinTests.py<br>Url: <a href="http://mail.python.org/pipermail/python-win32/attachments/20080317/b29565b5/attachment-0003.txt" target="_blank">http://mail.python.org/pipermail/python-win32/attachments/20080317/b29565b5/attachment-0003.txt</a><br>
<br>------------------------------<br><br>Message: 6<br>Date: Mon, 17 Mar 2008 12:53:23 -0500<br>From: "Tarun Kapoor" <<a href="mailto:tkapoor@wscm.net">tkapoor@wscm.net</a>><br>Subject: [python-win32] python 2.5<br>
To: <<a href="mailto:python-win32@python.org">python-win32@python.org</a>><br>Message-ID:<br> <<a href="mailto:C1E12E3378F89C4DA422B4089741418408B160@wscmmail.wscm.corp">C1E12E3378F89C4DA422B4089741418408B160@wscmmail.wscm.corp</a>><br>
Content-Type: text/plain; charset="us-ascii"<br><br>I want to use python win32 extensions on python 2.5 but it seems like<br>they were built for 2.3...<br><br>I copied the win32 folders from C:\python23\lib\site-packages to<br>
C:\python25\lib\site-packages but it does not work....<br><br>Is there a workaround ? anyone using it ?<br><br>-TK<br><br><br><br>Disclaimer<br><br>This e-mail and any attachments is confidential and intended solely for the use of the individual(s) to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Waterstone Capital Management, L.P and affiliates. If you are not the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, printing, forwarding or copying of this email is strictly prohibited. Please contact the sender if you have received this e-mail in error. You should also be aware that e-mails are susceptible to interference and you should not assume that the contents of this e-mail originated from the sender above or that they have been accurately reproduced in their original form. Waterstone Capital Management, L.P. and affiliates accepts no responsibility for information, or errors or omissions in this e-mail or use or misuse thereof. If in doubt, please verify the authenticity with the!<br>
sender.<br><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <a href="http://mail.python.org/pipermail/python-win32/attachments/20080317/82b9be5d/attachment.htm" target="_blank">http://mail.python.org/pipermail/python-win32/attachments/20080317/82b9be5d/attachment.htm</a><br>
<br>------------------------------<br><br>_______________________________________________<br>python-win32 mailing list<br><a href="mailto:python-win32@python.org">python-win32@python.org</a><br><a href="http://mail.python.org/mailman/listinfo/python-win32" target="_blank">http://mail.python.org/mailman/listinfo/python-win32</a><br>
<br><br>End of python-win32 Digest, Vol 60, Issue 28<br>********************************************<br></blockquote></div><br>