ojef1

thanks didnt take long enough to realize i was on page 6 when i clicked on it the first time...

Couldn't find it in the downloads section but I've seen threads where people reference it... thanks

then try using MouseClick for all of it then... use the Window Info tool to find the coordinates

first question have you tried using alt+D or something? If a letter is underlined on the toolbar alt+ that letter will select it. Once its in there you could arrow down or look to see if theres another hotkey combo second question you'll probably have to use MouseClick() function

I didnt see the colors every box was gray

Is there such a thing? I want to store the row number of whatever cell i happen to be in. This is kind of the idea, unfortunately "Activecell.Row" is a VBA command, not autoit. To make it simpler, I could even write the row numbers 1-whatever into a column...but even then I can't figure out how to extract that into an autoit variable. #include <Excel.au3> AutoItSetOption("SendKeyDelay", 500) $oExcel = _ExcelBookNew() Send("^g") ;go to cell Send("e4") ;random cell selection Send("{ENTER}") $Row = $oExcel.Worksheets(1).Activecell.Row ;would like this to equal 4 (or whatever row it happens to be) ConsoleWrite("Row: " & $Row "{ENTER}")

No I think you're right that should work fine...there's something wrong here I'll keep working at it though and report back if neccessary thanks for the help

That's what I thought but the errors I was getting made me believe otherwise so I combined the two into the same spreadsheet on separate sheets...That wasn't the problem though. Unfortunately, it's hard to tell what the issue is now. The reason I asked my original question is because (among other things) it would be really helpful to be able to search for a string (stored in a cell on spreadsheet A) on spreadsheet B without manually activating the window and using excels find function. Sort of like a VLookup but for excel objects I was hoping to run all of the excel stuff in the background without having to constantly switch between windows.

Thanks those should help a lot. Is it not possible to open up and reference two separate excel objects without switching between the two?

I've been looking through the help file and I see some of the examples using commands such as #include <Excel.au3> Local $oExcel = _ExcelBookNew() ;Create new book, make it visible [b]$iNumberOfWorksheets = $oExcel.Worksheets.Count[/b] MsgBox(0, "", $oExcel.Worksheets.Count) _ExcelSheetActivate($oExcel, 2) Is there a list somewhere of all the Excel Object commands ($oExcel.-----.----)?

My program involves many mouse clicks, which I designed for use on my computer. If I wanted to run it on a different machine, is there a way to either adjust the screen size on that machine to match mine or to automatically alter the coordinates in the code so that they all end up clicking on the correct spot?

Just wanted to say thank you to anyone who answered any of my questions over the past week or so. This was my first ever real program outside of some basic ones in school so I needed the help. I Just finished it today and it works perfectly (so far). I'll be compiling it and sending it out to some people to use over the next few days. (hopefully will be getting a nice bonus for this). Couldn't have done it without this forum even if some of the questions seem pretty trivial now. If anyone would like to look at it out of curiosity and maybe even make it more efficient or professional or whatever I'd be glad to share but its fully functional...thanks again...

That's wierd it works for me now too...I kept entering 'a' in all 3 textboxes and it still exited the loop and bypasses the error message. I can't imagine Mobius' suggestion fixed the problem, even though it was an improvement.....who knows thanks

Func input() While 1 GUICreate("Emax", 380, 180, @DesktopWidth / 4 - 160, @DesktopHeight / 4 - 45, -1, 0x00000018) GUICtrlCreateLabel("Enter the row to start with: ", 10, 5) $input1 = GUICtrlCreateInput("", 10, 25, 100, 20) GUICtrlCreateLabel("Enter the last row: ", 10, 50) $input2 = GUICtrlCreateInput("", 10, 65, 100, 20) GUICtrlCreateLabel("Enter a time delay (in milliseconds) in case the network is running slow: ", 10, 90, 350, 20) $input3 = GUICtrlCreateInput("", 10, 105, 100, 20) ;slows whole program down $enterBtn = GUICtrlCreateButton("Enter", 20, 145, 60, 20) $cancelBtn = GUICtrlCreateButton("Cancel", 100, 145, 60, 20) GUISetState() While 1 $msg = GUIGetMsg() If $msg = $GUI_EVENT_CLOSE Then Exit ElseIf $msg = $enterBtn Then $row = Int(GUICtrlRead($input1, 1)) $lastRow = Int(GUICtrlRead($input2, 1)) $delay = Int(GUICtrlRead($input3, 1)) ExitLoop ElseIf $msg = $cancelBtn Then Exit EndIf WEnd If ($row>0) And ($lastRow >= $row) Then ExitLoop Else MsgBox(48, "ERROR", "You must enter a valid integer and the last rows gotta be greater than or equal to the first row." EndIf WEnd EndFunc This is the full function (you make a valid point Mobius)...but no matter what the inputs are I can't get to the error message

click100() Func click100() MouseClick("left", default, default, 100) msgbox(0,"done", "done") EndFunc don't forget to call the function