siddhartha veedaluru usrdfattzuybapdgusrgmailcom bingo worked thanks tim mon mar 17 2008 1125 pm wrote send pythonwin32 mailing list submissions kpitckaew45pythonorg subscribe unsubscribe via world wide web visit httpmailpythonorgmailmanlistinfopythonwin32 via email send message subject body help gqljhvsyv93dxsffgqpythonorg reach person managing list lzlwpvttz39lzxddpythonorg replying please edit subject line specific contents pythonwin32 digest todays topics 1 pythonwin32 digest vol 60 issue 26 tim golden 2 skip altf4 le dahut 3 running sql queries excel sheets rickey kyle w 4 create com_record kevin patterson 5 confusion setforegroundwindow scott nelson 6 python 25 tarun kapoor message 1 date mon 17 mar 2008 115101 0000 tim golden subject pythonwin32 pythonwin32 digest vol 60 issue 26 cc kpitckaew45pythonorg messageid 85ss1j330689854timgoldenmeuk contenttype textplain charsetiso88591 formatflowed siddhartha veedaluru wrote hi tim tried snippet sent error opened python shell gave import wmi give error comobj_oleobj_gettypeinfogetcontainingtypelib0gettypecomp com_error 2147319779 library registered none none aha thats wanted know fact look original post informations shown shame checking looks though one wmi dlls system cwindowssystem32wbem need reregistered might something else however try running regsvr32exe dlls equivalent cwindowssystem32wbem im sorry involved ive never encountered someone error running wmi tjg message 2 date mon 17 mar 2008 141114 0100 le dahut subject pythonwin32 skip altf4 paul moore cc pythonwin32 list messageid 16cr4ol86318812lapostenet contenttype textplain charsetiso88591 formatflowed oh yes thats thank frame thats used service display information uncancelable forced reboot determinate modify informations displayed frame program run class frame get sort handler frame modify content text box dont know second way possible paul moore crit 17032008 le dahut wrote im writting wx app want skip altf4 ive used somehting like def onkeydownself event print eventaltdown eventgetkeycode eventaltdown eventgetkeycode wxwxk_f4 print try close everything gets printed app closes anyway altf4 way skip think hard reasonable reason overriding standard altf4 windows minimise tray rather closing b still want look onclose event override paul message 3 date mon 17 mar 2008 084045 0500 rickey kyle w subject pythonwin32 running sql queries excel sheets messageid contenttype textplain charsetusascii thanks john ill check kyle rickey original message john machin mailtozmsfhcxflexiconnet sent sunday march 16 2008 440 rickey kyle w cc kpitckaew45pythonorg subject pythonwin32 running sql queries excel sheets rickey kyle w wrote tim thanks response ive got 7 excel files need reading containing total 6100 rows agree code making sick thats exactly absolutely tons data one problem odbc approach reading spreadsheets least ms excel odbc driver examines limited number eg 8 10 rows determine type column first 10 rows floats column x noddys managed get text cell x11 fatal error odbc cant continue snip obviously helpful point reason cant pull data straight python structures take even push sqlite memory database perhaps youve got absolutely tons data extracting would pain consider using one com packages win32comclient comtypes something like pyexcelerator pull consider xlrd package httpwwwlexiconnetsjmachinxlrdhtm itll tell type data cellbycell compare expectations hth john message 4 date mon 17 mar 2008 121826 0400 kevin patterson subject pythonwin32 create com_record nkpmuffqskippinetcomau cc pythonwin32 list messageid contenttype textplain charsetiso88591 case helps heres overall description comapp function fits com_app typelib multiple classes interfacing application controls hardware usb port multiple applications started becomes impossible users write code accessing particular instance app therefore manager com com_manager created two important level com_manager first call gets object representing particular application really com_app perse another object handles app somefunction gives particular class particular com_app takes guid parameter im still learning details com guess vt_record sort standard way passing structure information back forth email access first half week fairly limited ill still try learn way around test harness see create example sat mar 15 2008 1254 pm mark hammond wrote clarify hresult somefunction guid pguid retval iid_ispguid iunknown ppunknown win32com says needs vt_record order pass guid information com previous email exchanges cant deifne guid understanding idispatch implementation method declares wants vt_record win32com trying comply get back home approach simply try repro issue win32com test suite least give clearer picture happening kevin could take steps towards would help cheers mark next part html attachment scrubbed url httpmailpythonorgpipermailpythonwin32attachments20080317a1a03bc2attachment0001htm message 5 date mon 17 mar 2008 120932 0500 scott nelson subject pythonwin32 confusion setforegroundwindow kpitckaew45pythonorg messageid 3908vt2p1506439639g85123p5momt96n90851opp506mailgmailcom contenttype textplain charsetiso88591 greets im looking use win32api win32gui modules bit windows tinkering win2k activestates python 241 distribution ive hit snag id like processwindow steal focus whatever window currently get bit input keyboard restore focus back original window simple cases win32guisetforegroundwindowhwnd seems im looking works fine simply try set focus another window app im seeing unexpected behavior go beyond wrote simple test script enumerates visible windows tries give one focus turn short delay gets 12 windows 810 nonminimized windows open ie notepad wordpad etc gives traceback recent call last file d_codepythonappswintestspy line 25 cycle_foreground file d_codepythonappswintestspy line 20 cycle_foreground win32guisetforegroundwindowhandle pywintypeserror 0 setforegroundwindow error message available wrong case bad assumptions app allowed give away focus cant force different apps window focus give away focus way accomplish ive attempted using mix setfocus bringwindowtotop enablewindow couldnt find magic combo ive attached test script run wintests cycle attempt cycle focus top level windows see traceback run wintests 12345 successfully set focus window hwnd 12345 run wintests get list top level window names hwnds ive tried reading win32 docs provided activestates pythonwin ive read bit win32 api msdn ive googled around bit havent found much got curious tried code something similar c uses identical api calls tell seems problem cycling toplevel windows ive attached cpp file well discrepancy im seeing win32gui c thoughts scott next part embedded charsetunspecified text scrubbed name setforegroundwindowcpp url httpmailpythonorgpipermailpythonwin32attachments20080317b29565b5attachment0002txt next part embedded charsetunspecified text scrubbed name wintestspy url httpmailpythonorgpipermailpythonwin32attachments20080317b29565b5attachment0003txt message 6 date mon 17 mar 2008 125323 0500 tarun kapoor subject pythonwin32 python 25 messageid contenttype textplain charsetusascii want use python win32 extensions python 25 seems like built 23 copied win32 folders cpython23libsitepackages cpython25libsitepackages work workaround anyone using tk disclaimer email attachments confidential intended solely use individuals addressed views opinions presented solely author necessarily represent waterstone capital management lp affiliates intended recipient advised received email error use dissemination printing forwarding copying email strictly prohibited please contact sender received email error also aware emails susceptible interference assume contents email originated sender accurately reproduced original form waterstone capital management lp affiliates accepts responsibility information errors omissions email use misuse thereof doubt please verify authenticity sender next part html attachment scrubbed url httpmailpythonorgpipermailpythonwin32attachments2008031782b9be5dattachmenthtm _______________________________________________ pythonwin32 mailing list kpitckaew45pythonorg httpmailpythonorgmailmanlistinfopythonwin32 end pythonwin32 digest vol 60 issue 28 wed 06 aug 2008 092926 0530 pythonwin32 library registered error running