dazza

Hmm. You have me perplexed MrMitchell... $color = $headcount_excel.Selection.Interior.ColorIndex This returns a value of 19. But... 1) The excel udfs do not cover this function (it matters not mind) 2) How do I select a specific cell? If 2) can be answered then I'm a happy bunny. Many thanks

Dear Boffins, Is there anyway of getting a cell colour in a spreadsheet? The excel udfs only cover the basic. I hope so; I don't want to resort to VBAing the result--I'd like to keep everything AutoIT. Ta

AhA! I think I have found the problem. I AutoIT recursive error came up--out of the blue. I reckon... as I am testing across different users (sys admin, standard user etc.) I had two instances of autoit running... somehow. By ghosting back a previous version and avoiding putting the autoIT exe in ALL USERS and login USER, this problem will be absent. Famous last words. Opt("TrayIconDebug", 1) <-- never knew this. Nice one.

I (may be proved wrong) don't think more code or any code is relevant here. I've never heard of AdLibRegister mind: but I don't get out much. The core of my frustration is; 1) This code has worked in the past dozens of times 2) A smaller sleep (10) works but only passes on the problem. 3) The only change to the mix is that it's Monday There is something technical glitchy that my code at this particular time on Monday (always a Monday) has stumbled on. How can a SLEEP fail? The code chews through over a dozen SLEEPS before it gets to this pivotal SLEEP and then *ucks off to play WOW. I'll re-instal AutoIT--this may fix the problem. <shrug>

The tool automates another computer using VNC. This snippet of code has worked for weeks; nothing has changed. The second consolewrite just doesnt happen anymore. ;Open VNC ShellExecute("C:\Documents and Settings\Test\Desktop\vncviewer.exe") sleep(3000) send("{ENTER}") sleep(3000) ;Restart terminal send("{LWIN}") sleep(2000) send("u") sleep(2000) send($key) sleep(2000) send("{TAB}") sleep(2000) send("{ENTER}") consolewrite("here") sleep(10000) consolewrite("there")

This a weird one. A SLEEP(5000) is just freezing. If I reduce the delay to 10, the sleep works but the next SLEEP then freezes. There is no other processes running. I have tried deleting the whole line and re-typing. I have two other AutoIT coders look at this and we are all perplexed. Is there a limit or barrier or trans-dimensional worm hole that can cause a simple SLEEP to fail. This is ruining my morning

Brilliant! Apologies for not seeig this in the help.

People, Is there a simple way for setting the GUI to have a picture background. If I put a guictrlcreatepic to cover the whole GUI, other controls I dump ontop become invisible (or set behind) ie listviews even If I add the listview AFTER the pic. Perhaps there is a draw order command available. Many thanks for any help.

Thank you guys. Super stuff.

$pic = GUICtrlCreatePic($PICS & "picture.jpg", 10, 265, 80, 80) How do I stop the picture being resized in the 80 by 80 dimensions? I don't want it stretched. Clipped is fine. Thanks

Aye karumba! What a load of work to just get a red outlined square. Many thanks Malkey. Maybe the boffins at AutoIT could just fix the GUICtrlSetColor function. Over and out.

Many thanks; I can actually ditch the label and just use the graphic. But... I need this red square on top of a jpg (GUICtrlCreatePic) and even though I have created the PIC before the GRAPHIC, the GRAPHIC is hidden by the PIC.

It seems that the SetColor command is just ignored as black is always the outline colour. $k = GUICtrlCreateLabel("", 10, 500, 20, 20, $WS_BORDER) GUICtrlSetColor($k, 0xFF0000) GUICtrlSetBkColor($k, $GUI_BKCOLOR_TRANSPARENT) I am clearly missing something fundamental... and after all these years. I hang my head.

Brilliant! I will remember that.

I'm being thick... I've trawled through the UDFs and I can't find a way to scroll in a listview to show the selected item.

Many thanks. Appreciate the time.

Oh... Shame. Thanks for the link. Ok. By default what is the bkcolor of the button. I don't mind making it blue (this temporary ruins the spaciong) but then returnuing the button to its default state (ie no bkcolor set). So... $key = GUICtrlCreateButton("! 1", $across, $down, 30, 30, $BS_MULTILINE) I blue it: GUICtrlSetBkColor($key, 0xBBBBBB) Now how do I return it to the initial state? (ie no color)

Ack. This button shows the !1 as one above the other (as in the "1" on a keyboard) $key = GUICtrlCreateButton("! 1", $across, $down, 35, 30, $BS_MULTILINE) But on setting the bkcolor GUICtrlSetBkColor($key, 0xBBBBBB) The multiline is cancelled. How odd. Gurus, how can I have both?

That'll do it. I'd thought I'd be lazy and avoid that way. But... this way is quicker later on. Ta triblade.

Gurus, I have a GUI with 100 odd buttons I have created. I need to loop through each one and query the Text on it. Pseudocode: For each button on my GUI ;do stuff Next Thanks in advance.

To join SPECTRE and take over the world!!!!! MUHAHAHHAHAH <-- evil laugh Give an advanced member some credit. The routine already captures keys; I'm simply asking for a more codey efficient way.

My code is this: $dll=DllOpen("user32.dll") For $key = 32 to 126 $hex = hex($key) If _IsPressed($hex, $dll) Then consolewrite($hex & "/" & chr($key) & @crlf) $key = 127 While _IsPressed($hex) = 1 WEnd EndIf Next Is there a way I can return the key without looping through? Maybe a switch or querying the dll and returning the key value?

It's official: Melba23 is a 'clever' person. This works a treat and will be forever saved in my own AutoIT 'clever stuff' library. Many thanks

Dear Clever people, How do I modify this code (in _GUICtrlListBox_Create) to detect notifications from 2 listboxes. Assume the listboxes are called: $hListBox and hListBox2 Func WM_COMMAND($hWnd, $iMsg, $iwParam, $ilParam) #forceref $hWnd, $iMsg Local $hWndFrom, $iIDFrom, $iCode, $hWndListBox If Not IsHWnd($hListBox) Then $hWndListBox = GUICtrlGetHandle($hListBox) $hWndFrom = $ilParam $iIDFrom = BitAND($iwParam, 0xFFFF) ; Low Word $iCode = BitShift($iwParam, 16) ; Hi Word Switch $hWndFrom Case $hListBox, $hWndListBox Switch $iCode Case $LBN_DBLCLK ; Sent when the user double-clicks a string in a list box _DebugPrint("$LBN_DBLCLK" & @LF & "--> hWndFrom:" & @TAB & $hWndFrom & @LF & _ "-->IDFrom:" & @TAB & $iIDFrom & @LF & _ "-->Code:" & @TAB & $iCode) ; no return value

Does AutoIT have a clever way to unzip a file and read the contents of the unzipped file?