Sign in to follow this  
Followers 0
Zombie1982

Check external string

3 posts in this topic

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.

Share this post


Link to post
Share on other sites



#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

Share this post


Link to post
Share on other sites

#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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0