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.