shikherg Posted May 14, 2016 Posted May 14, 2016 i have a list of usernames and passwords in an excel file (row 1 : username1, password1, row 2 : username2, password2 ... likewise) the work (login, do some work, log out, login with second user, do same work, log out.. likewise) is same for each user. how do i create a script with that?
alien4u Posted May 14, 2016 Posted May 14, 2016 Hi @shikherg and welcome to the AutoIt Forum. From the AutoIt help file you should see this functions which are part of the Excel UDF: _Excel_RangeRead() And also if you are going to login to a website you need to look in to IE UDF Examples and everything is on the help file. After you try something and you got a problem you can publish here your problem and your code and we will help you. Regards Alien.
water Posted May 14, 2016 Posted May 14, 2016 Welcome to AutoIt and the forum! I'm a bit curious. Why would you have userids and passwords in an Excel workbook? That's a big security weakness! How many users are we talking about? What is the work you need to do with all those users? Something in a corporate network or the Internet? My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
shikherg Posted May 14, 2016 Author Posted May 14, 2016 1 hour ago, water said: Welcome to AutoIt and the forum! I'm a bit curious. Why would you have userids and passwords in an Excel workbook? That's a big security weakness! How many users are we talking about? What is the work you need to do with all those users? Something in a corporate network or the Internet? my clients has a lot of clients.. some tax firm..
alien4u Posted May 14, 2016 Posted May 14, 2016 4 hours ago, shikherg said: my clients has a lot of clients.. some tax firm.. Very nice and cool... they maybe but almost sure pay you very well... so we still need you do something.... And show us your specific problem.... Regards Alien.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now