Sign in to follow this  
Followers 0
tedesco

Very Simple Script that I can not fugure out

4 posts in this topic

Extreme Noob! Please help me. I am trying to do the simplest thing with Autoit and can not find any help or create the script myself. Here is what I need: I have 500 users that need to have a second email account added to there outlook 2010 client. What I wanted the scrip to do was have the users enter there username into a input box then it will do a search from the "master" excel file and if there name was found it autopopulate the information into outlook with password then delete the cell in the excel file. Here is what I wrote (please be nice)Any help would be very much appreciated. Please remember I am sooo not a programer but need this for work ASAP. Search.au3

Share this post


Link to post
Share on other sites



General Help and Support forum is for you.

Share this post


Link to post
Share on other sites

i agree, wrong forum section. maybe the mods will move this topic?

Share this post


Link to post
Share on other sites

I cleaned up the syntax errors and added some error detecting code. Run it and see what it says.

#include <Excel.au3>
#include <Array.au3>

$sFilePath1 = "C:\DOT.xls"

$oExcel = _ExcelBookOpen($sFilePath1)

If Not $oExcel Then
    MsgBox( 32 , "@error: " & @error , "_ExcelBookOpen() FAIL" )
    Exit
EndIf

$Select_Col = 1

$sCellValue = _ExcelReadCell($oExcel, $Select_Col)

If Not $sCellValue Then
    MsgBox( 32 , "@error: " & @error , "_ExcelReadCell() FAIL" )
    Exit
EndIf

$sSearch = InputBox("Enter name:", "find Name")

If $sCellValue = $sSearch Then
    MsgBox(0, "GAOL", "Name Found")
Else
    MsgBox(0, "FAIL", "Name Not Found")
    Exit
EndIf

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