Jump to content
Sign in to follow this  
SerHenning

Excel adding 1 to the cell value

Recommended Posts

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)

 

Share this post


Link to post
Share on other sites

You could simply read the whole column in one go and then retrieve A1, A2 ... from the returned array.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2020-10-10 - Version 1.5.2.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2020-12-15 - Version 1.6.3.1) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2020-06-27 - Version 1.3.2.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - 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
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - 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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...