SerHenning Posted July 25, 2019 Posted July 25, 2019 Hey, I'm trying to do a process which involves copying a cell from Excel, then repeat that process but copying the next cell and so on. Is there any simple way to do that? I got my entire paste process and I can copy one cell, which I wrote down, e.g. A1 and now I want to copy A2, A3 and so on. I think I gotta make the cell value a variable but I'm pretty sure its more than that, as it got an A in front of it. Ignore my way of opening the editor please 🤣 #include <IE.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> Local $var = "C:\Users\Jan\Documents\Projekte\Autoitlernen\excel\testitest.xlsx" Local $oExcel_1 = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel_1, $var) Local $_read = _Excel_RangeCopyPaste($oWorkbook.Activesheet, "A2") send ("{LWIN}") Sleep (1000) send ("e") Sleep (200) send ("d") Sleep (200) send ("i") Sleep (200) send ("{ENTER}") Sleep (1000)
water Posted July 25, 2019 Posted July 25, 2019 You could simply read the whole column in one go and then retrieve A1, A2 ... from the returned array. My UDFs and Tutorials: Reveal hidden contents 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
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