Jump to content
Sign in to follow this  
gauravvogue

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

Recommended Posts

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

Share this post


Link to post
Share on other sites
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.


√-1 2^3 ∑ π, and it was delicious!

How to get your question answered on this forum!

Share this post


Link to post
Share on other sites
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).


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2018-12-03 - Version 1.4.11.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (2018-10-31 - Version 1.3.4.1) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
 
Tutorials:

ADO - Wiki

 

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  

×