EasyGoing

I run a daily report process that I am trying to us Autoit, but one of the pieces of info is in a message box. I run the steps and then the application pops up a message box saying "your spool number is 393939. I need to use the spool number later on in the code to call up the run with the spool number. How do I get the spool number out of the messge box so I can copy it in the applicaiton????

I have run script that uses the ShellExecute to open the application. What I would like to do is connect to the data (excel, SQL server MDB database) and pull data from a view or table. Then use the data to send keystrokes to another application. How do I establish the connect to the database or data file?

I am coping a cell in excel and then valuating it in a IF statement. my code works if the value is numeric, but it errors if it is text. Can anyone hlep with this? Is it because the copy clipboard has triming issues? or what. inActivate("Microsoft Excel - question.xls") WinWaitActive("Microsoft Excel - question.xls") Send("^c") Sleep(100) $occupation = ClipGet() If $occupation = "test" Then Send("{DOWN}") Sleep(1000) Send("it works") ;send($occupation) Else Send("{DOWN}") Sleep(1000) Send("did not work") ;Send($occupation) EndIf

My statement works if I change the variable to a numberic value. The issue is in the string or format that the clipboard is in. IF i change the "test" to 1 and run the script is works. What do you thing it is? Everything else works. copy paste variable all works. It just will not read the char type or string type. WinActivate("Microsoft Excel - question.xls") WinWaitActive("Microsoft Excel - question.xls") Send("^c") Sleep(100) Dim $occupation $occupation = ClipGet() If $occupation = "test" Then Send("{DOWN}") Sleep(1000) send($occupation) Else Send("{DOWN}") Sleep(1000) Send($occupation) Send("did not work") EndIf

Thank you, but it still does not work. I copied and pasted your codes and it jumps to the else statement " It does not work". I does not even do the other send commands.

I am trying to copy a cell in excel and then valuate it. here is my code that doe snot work. I get a error WinActivate("Microsoft Excel - question.xls") WinWaitActive("Microsoft Excel - question.xls") Send("^c") Sleep(100) $occupation = ClipGet() If if $occupation = "Tenet" Then Send("{ENTER}") Sleep(100) SEND("^V") Else Send("{ENTER}") Sleep(100) SEND("Did not work") EndIf

[Everything works great now. I need a little. Please point me in the right direct to build code on: using a "IF" conditon to valuate a fild in excel then use keystroke in another application. Example IF WinWaitActive("Microsoft Excel - question.xls") A14 = "Yes" then WinWaitActive("Microsoft Excel - Answer.xls") esle send({space}) else send({TAB})

How did you get the symble next to the c? Send("^c") I tried to use the clipput and clipget but I think your way is better with copy and paste. Thank you again for your answer.

Thank you. You are right this will work for now. I would like to make is clean in the future as my skills improve. The next thing I need to learn is the "conditon" I have a lot of check boxes that need a "Yes" or "No" before I check them. Do you have a simple example of this. Something like this. IF cell in excel a14 = Yes then send({space}) else send({TAB})

I am new and trying to open an excel file data.xls I tried to use run but it needs an exe file. run("data.xls","c:\\") How do I open an excle file that has been saved with data?

I am new to scripting and do not want to use software like automate. I think autoit is easy to use, but need help understanding how to use it. I have a lot of processes that require moving data from excel to a hospital system. I can use copy\ paste. method or keystroke from excel to the other application. Does anyone have a good example to show me? or explain how should get started. I do not see any example on the web. Thank you.