Zombie1982 Posted August 14, 2008 Share Posted August 14, 2008 Good afternoon, I'm a very new user whom may have bitten off more that I can chew. I've recently began to write a script that copies data from an excel spreadsheet and dumps it into another application. So far Autoit has been amazing. Now it needs to be idiot proofed. Basically I'm wondering if there is a way to check whats written in a cell in excel and return an error if its not what I want it to be. Any help or suggestions would be welcomed. I've had a look at the extensive help file and a look around the forums and while its given me some ideas, I just can't seem to concrete to process. Link to comment Share on other sites More sharing options...
Andreik Posted August 14, 2008 Share Posted August 14, 2008 #Include <Excel.au3> $oExcel = _ExcelBookOpen(@ScriptDir & "\Doc.xls",0) $CELL = _ExcelReadCell($oExcel, 1, 1) If $CELL = "WHAT YOU WANT" Then MsgBox(0,"",$CELL) _ExcelBookClose($oExcel) Look in help file for more informations. When the words fail... music speaks. Link to comment Share on other sites More sharing options...
Zombie1982 Posted August 14, 2008 Author Share Posted August 14, 2008 #Include <Excel.au3> $oExcel = _ExcelBookOpen(@ScriptDir & "\Doc.xls",0) $CELL = _ExcelReadCell($oExcel, 1, 1) If $CELL = "WHAT YOU WANT" Then MsgBox(0,"",$CELL) _ExcelBookClose($oExcel) Look in help file for more informations. Champion, thank you very much. I'll look into it, but it looks as though thats exactly what I want. Can't thank you enough. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now