How to activate a excel workbook in a program a multiple times

[gauravvogue]

 

 

Hi Team.

 

I have written a program to sent a auto mail by coping some data from excel sheet.

For that i have to activate an excel sheet a multiple times to copy multiple data in sender list and in subject list.

I just want to activate excel sheet a multiple times in my program so that i can copy a multiple data at different time stamps

 

I am attaching my program here

uploaded program.au3

[JLogan3o13]

Hi, guaravvogue. I would highly suggest you use the Excel functions built into AutoIt. They are much more stable than all the MouseMoves, and will allow you to pull data from any sheet in the workbook, without having to worry about activating the window first.

[water]

I suggest to use the latest version of AutoIt (seems you use 3.3.8.1 or older).The new Excel UDF that comes with version 3.3.12.0 or later is much more powerful (but has a lot of script breaking changes).