Jump to content

Check external string


Recommended Posts

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

#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

#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

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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...