1. Dashboard
  2. Mitglieder
    1. Letzte Aktivitäten
    2. Benutzer online
    3. Team
    4. Mitgliedersuche
  3. Forenregeln
  4. Forum
    1. Unerledigte Themen
  • Anmelden
  • Registrieren
  • Suche
Alles
  • Alles
  • Artikel
  • Seiten
  • Forum
  • Erweiterte Suche
  1. AutoIt.de - Das deutschsprachige Forum.
  2. Mitglieder
  3. Bernd Albrecht

Beiträge von Bernd Albrecht

  • Solange sleep bis die eine Bestimmte Farbe an einer Position auftritt

    • Bernd Albrecht
    • 22. Juni 2021 um 15:58
    Zitat von water

    Was hast Du schon probiert?

    Bist ja schon über ein Jahr hier und somit kein Newbie mehr

    Ich wollte mit dem hier ran; merkte aber dann, das das nicht helfen wird:

    $pixel = PixelGetColor( 814, 437 )

    $hexColor = "0x" & Hex($pixel)

    If $hexColor = 0xECB55A Then

    MouseClick("left" , 1305,431 , 1);

    Sleep(Random(14050, 16650, 1))

    MouseClick("left" , 708,334 , 1);

    Sleep(Random(2050, 4650, 1))

    MouseClick("left" , 1259,120 , 1);

    Sleep(Random(23050, 29650, 1))

    EndIF

    Ich hab noch die Suchfunktion benutzt, leider ohne Ergebnisse. Ich benutze ein Autoit Skript, AutoIT Exeperte bin ich leider nicht und werde ich vermutlich auch nie werden.

  • Solange sleep bis die eine Bestimmte Farbe an einer Position auftritt

    • Bernd Albrecht
    • 22. Juni 2021 um 15:25

    Hi Leute,

    kann mir jemand bei folgendem helfen?:
    Ich möchte das AutoIT solange schläft, bis sich eine bestimmte Farbe an einer bestimmten Position einstellt. Konkret, AutoIT soll solange schlafen bis sich an der Position 1007, 737 die Farbe 0xE9E9E9, einstellt.

    Ich danke euch im vorraus für eure Antworten.

    Gruß Bernd

  • langsames eingeben von Si Count

    • Bernd Albrecht
    • 20. April 2021 um 23:48
    Zitat von Musashi

    Meinst Du so etwas ?

    AutoIt
    Opt('SendKeyDelay', 250); Zeit in Millisekunden , default 5
    
    Run("notepad.exe")
    Local $hWnd = WinWait("[CLASS:Notepad]", "", 10)
    
    Send("Zeit/Datum ist = {F5}")
    
    ; Notepad beenden :
    Sleep(2500)
    WinClose($hWnd)
    WinWaitActive("[CLASS:#32770]")
    Sleep(500)
    Send("{TAB}{ENTER}")
    Alles anzeigen

    Vielen dank, Nun hat es doch irgendwie mit SendKeyDelay in Kombination mit weiteren kleinen Änderungen geklappt.

  • langsames eingeben von Si Count

    • Bernd Albrecht
    • 20. April 2021 um 22:16

    Wie kann ich es so einrichten, das Autoit die tasten langsamer drückt.
    Send("{PGDN} " & $iCount & "}")
    Ab einem gewissen Si Count drückt er anscheinend zu viel und zu schnell so.

    Sendkeydelay hat bisher nicht funktioniert.

  • 2 Schleifen nacheinander laufen lassen

    • Bernd Albrecht
    • 20. September 2020 um 15:28

    @Musashi und water

    ja, aktuell habe ich 2 Skripte für A und B.

    Der Aufbau meiner jeweils beiden Skripte ist wie schon oben von mir gezeigt, und nicht wie water gezeigt hat. ( FOr next...)

    2mal:

    #Region

    #AutoIt3Wrapper_Au3Check_Parameters=-q -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 -w 7

    Opt('MustDeclareVars', 1)

    #include <Excel.au3>

    Global $oExcel_1 = _Excel_Open()

    Global $var = "G:\x\x.xlsx"

    Global $oWorkbook = _Excel_BookOpen($oExcel_1,$var)

    WinActivate("Read ideal - Microsoft Excel")

    sleep(15000)

    Global $_readA, $_readB, $_readC,...

    Global $aRanges =...

    ...

    ...

    ...

    For $i = 0 To 19 Step 1

    $_readA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][0])

    $_readB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][1])

    $_readC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][2])

    $_readD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][3])

    $_readE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][4])

    $_readF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][5])

    .....

    ....

    XXXXXXXXX ($kordinater, $HWND ,$_readA, $_readB, $_readC, $_readD, $_readE, $_readF, $_readG, $_readH, $_readI, $_readJ,...)
    Next

    Func A

    ....Befehle

    ....

    ....

    EndFunc

    müsste ich nun eine zweite Funktion definieren ?Die Parameter meiner Zweiten funktion sind identisch mit meiner ersten.

    Gruß Bernd

  • 2 Schleifen nacheinander laufen lassen

    • Bernd Albrecht
    • 19. September 2020 um 19:39

    water Danke für deinen Tipp, Aktuell bin ich mit meiner Range ziemlich zufrieden, es dauert immer zwar ca. 30-90 Sekunden bis das Skript alles geslesen hat und beginnt, aber diese paar sekunden stören mich nicht, es lief auch so bisher fehlerfrei ( PS: Das was ich oben reingeschriebn hatte ist nicht mein gesates Skript, da wo die Punkte sind, sind in wirklichkeit noch andere Sachen, Bspw. meine Range/Array/....

    Ich nehme anhand eurer Antworten an, das mein Vorhaben, 2 Schleifen hintereinander laufen zu lassen, nicht möglich ist und ich gewzungen bin diese immer seperat laufen lassen muss.

    Gruß Bernd

  • 2 Schleifen nacheinander laufen lassen

    • Bernd Albrecht
    • 19. September 2020 um 11:58

    Hi Leute,

    wie kann man 2 verschiedene Schleifen hinteinander laufen lassen. Sprich ich möchte, das zunächst Funktion A 20 mal ausgeführt wird, sobald diese FUnktion endet soll Funktion B 20 mal ausgeführt werden. Aktuell muss ich immer warten bis Funktion A beendet ist und dann das Skript der FUnktion B öffnen und es manuell starten.

    #Region

    #AutoIt3Wrapper_Au3Check_Parameters=-q -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 -w 7

    Opt('MustDeclareVars', 1)

    #include <Excel.au3>

    Global $oExcel_1 = _Excel_Open()

    Global $var = "G:\x\x.xlsx"

    Global $oWorkbook = _Excel_BookOpen($oExcel_1,$var)

    WinActivate("Read ideal - Microsoft Excel")

    sleep(15000)

    Global $_readA, $_readB, $_readC,...

    Global $aRanges =...

    ...

    ...

    ...

    For $i = 0 To 19 Step 1

    $_readA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][0])

    $_readB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][1])

    $_readC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][2])

    $_readD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][3])

    $_readE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][4])

    $_readF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][5])

    .....

    ....

    Func A

    ....

    ....

    ....

    EndFunc


    Ich danke euch im vorraus für eure Aufmerksamkeit

    Gruß Bernd

  • Website auf neue Downloads untersuchen

    • Bernd Albrecht
    • 8. August 2020 um 19:27

    Hallo Leute,

    ist es möglich mit AutoIt eine Website ( die gesamte website) darauf zu untersuchen ob neue Downloads zur verfügung stehen?
    Auf vexels.com erscheinen täglich neue Dowload´s, die findet man aber erst nach ca. 10 Tagen ( suche ergibt keine Treffer; erscheint nicht bei "newest"). Wenn mann aber den Link mit der NUmmer kennt, kann man schon früher diese Dateien downloaden. Ich bin Mitglied bei vexels.

    Bsp. Link : https://de.vexels.com/vectors/preview/218636/kein-inhalt
    Diese Panda Grafik findet man noch nicht über suchen, erst in einigen Tagen, sie ist aber schon aber auf der Seite existent.

    Ich danke euch im vorraus für eure Antworten

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 21. Juli 2020 um 21:39

    autoiter danke für deine Verbesserungsvorschläge.
    Das mit der Zelle war schon nervig für mich und mein Skript braucht wirklich so 1 min bis es beginnt. Könnte ich es beispielsweise so abkürzen ?:

    Code
    Global $aRanges =        [    ['B2',- 'B61',], _ ?

    oder gibt es da eine spezielle Metodik wie man das machen kann?

    Mit dem Internet Eplorer und dem IE.au3 hatte ich mich schon beschäftigt gehabt, leider gab es da einige Hirden. Die Plattformbetreiber haben Ihre Seite so eingerichtet, das man keine ID´s und Namen hat, also hatte ich es aufgegeben.

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 21. Juli 2020 um 20:57

    Bsp. Region

    Code
     #include <AutoIt>
    
    #Region Shirtee DE
    Select
        Case $_readAG = 1
            Select
                Case  $_readH = 1
                    ShellExecute("firefox.exe", "https://www.shirtee.com/de/customer/account/login/")
                Case Else
                    ShellExecute("https://www.shirtee.com/de/customer/account/login/")
            EndSelect
            sleep(15000)
            MouseClick("left" , 673,365 , 1)
            Sleep(Random(500, 1500, 1))
            Send("{END}")
            Sleep(Random(1500, 2500, 1))
            Send("{PGUP}")
            sleep(1000)
            MouseClick("left" , 668,310 , 1); Klick auf anmelden
            sleep(8000)
            MouseClick("left" , 509,528 , 1); Klick Pop-Up Snekung mehrwertsteuer
            sleep(2000)
            MouseClick("left" , 504,513 , 1); Klick Pop-Up
            sleep(2000)
            MouseClick("left" , 570,325 , 1); Random
            sleep(500)
            Send("{END}")
            Sleep(Random(1500, 3500, 1))
            Send("{PGUP}")
            MouseClick("left" , 776,607, 1); Klick Produkte verkaufen
            Sleep(Random(9500, 15500, 1))
            MouseClick("left" , 226,721, 1); Bilder löschen
            Sleep(Random(12500, 16500, 1))
            MouseClick("left" , 431,502 , 2); Computer dursuchen
            Sleep(Random(1000, 1500, 1))
            MouseClick("left" , 390,506 , 1); Computer dursuchen 2
            sleep(1000)
            MouseClick("left" , 520,508 , 1); Computer dursuchen 3
            sleep(4000)
            WinSetState("Datei hochladen", "", @SW_MAXIMIZE)
            sleep(1000)
            ;$HWND = WinWaitActive("Datei hochladen", "")
            sleep(500)
            ControlClick("Datei hochladen", "", "[CLASS:ToolbarWindow32; INSTANCE:3; ID:1001]"); !!!wichtigKlick auf Suchleiste des Ordners ( Datei hochladen),markiert diesen automatisch
            sleep(1000)
            send("{backspace}") ; löschen
            sleep(1000)
            send("C:\Users\PPPPPP\Desktop\x")
            sleep(1000)
            send("{ENTER}")
            sleep(2000)
            MouseClick("left" , 230,155 , 1); klick erstes Bild                                ; ßßßßßßß: Mousklick Bild ( hier 1)
            sleep(1000)
            Send("{Right " & 2+$iCount*2 & "}")
            Sleep(Random(1000, 3500, 1))
            ControlClick("Datei hochladen" ,"", "[CLASS:Button; INSTANCE:1; ID:1]")
            Sleep(Random(26500, 32500, 1))
            Select; Farbe am Anfang
                Case $_readC=11 Or $_readC=13 Or $_readC=1 Or $_readC=3 Or $_readC=6 Or $_readC=8 Or $_readC=16
                    MouseClick("left" , 105,709 , 1); Random
                    sleep(1000)
                    MouseClick("left" , 1115,601 , 1); Mausklick Farbe Schwarz
                Case $_readC=2 Or $_readC=4 Or $_readC=5 Or $_readC=7 Or $_readC=9 Or $_readC=10 Or $_readC=12 Or $_readC=14  Or $_readC=15 Or $_readC=17 Or $_readC=18
                    MouseClick("left" , 105,709 , 1); Random
                    sleep(1000)
                    MouseClick("left" , 1117,500 , 1); Mausklick Farbe weiß
                Case Else
                    MouseClick("left" , 105,709 , 1); Random
                    sleep(1000)
                    MouseClick("left" , 1117,500 , 1); Mausklick Farbe weiß
            EndSelect
            Sleep(Random(1000, 1500, 1))
            Send("{END}")
            Sleep(Random(1000, 1500, 1))
            Send("{PGUP}")
            Sleep(Random(1000, 1500, 1))
            MouseClick("left" , 1014,421 , 1); Klick Zum Nächsten Schritt
            Sleep(Random(2000, 2500, 1))
            MouseClick("left" , 1045,421 , 1)
            sleep(2000)
            Send("{PGUP}")
            Sleep(Random(500, 1000, 1))
            Send("{PGUP}")
            sleep(1500)
            MouseClick("left" , 287,598 , 1); Klick Vorlage laden
            Sleep(Random(1300, 1800, 1))
            Select; Auswahl Vorlage
                Case $_readC = 15 Or  $_readC = 5 Or  $_readC = 10 Or  $_readC = 18
                    MouseClick("left" , 837,328 , 1); 15
                Case $_readC = 14 Or  $_readC = 4 Or  $_readC = 9 Or  $_readC = 17
                    MouseClick("left" , 843,427 , 1); 14
                Case $_readC = 13 Or  $_readC = 3 Or  $_readC = 8 Or  $_readC = 16
                    MouseClick("left" , 842,521 , 1); 13
                Case $_readC = 12 Or  $_readC = 2 Or  $_readC = 7
                    MouseClick("left" , 496,421 , 1); 12
                    sleep(500)
                    Send("{END}")
                    sleep(500)
                    MouseClick("left" , 833,582 , 1)
                Case $_readC = 11 Or  $_readC = 1 Or  $_readC = 6
                    MouseClick("left" , 840,617 , 1); 11
                Case Else
                    MouseClick("left" , 837,328 , 1); 15
            EndSelect
            Sleep(Random(5000, 7500, 1))
            MouseClick("left" , 86,337 , 1) ; Random
            Send("{END}")
            Sleep(Random(1500, 1800, 1))
            Send("{PGUP}")
            Sleep(Random(1000, 1300, 1))
            MouseClick("left" , 817,412 , 1); Klick Zum Nächsten Schritt 2
            Sleep(Random(7000, 8500, 1))
            Send("{END}")
            sleep(1000)
            MouseClick("left" , 24,218 , 1); Random
            sleep(1500)
            Send("{PGUP}")
            sleep(500)
            Send("{PGUP}")
            sleep(1500)
            Send("{PGUP}")
            sleep(500)
            Send("{PGUP}")
            Sleep(Random(1500, 1900, 1))
            Opt("SendKeyDelay", 180)  ;                                                        langsame tasteneingabe
            MouseClick("left" , 336,402 , 1); Titel
            Sleep(Random(5000, 6500, 1))
            send($_readA)
            Sleep(Random(2000, 3500, 1))
            MouseClick("left" , 67,393 , 1); Random
            sleep(500)
            Send("{PGDN}")
            Sleep(Random(1000, 1500, 1))
            MouseClick("left" , 446,398 , 1) ;Marktplatz
            Sleep(Random(1000, 1500, 1))
            send("G") ; German
            Sleep(Random(1000, 1500, 1))
            Send("{ENTER}")
            Sleep(Random(1000, 1500, 1))
            Opt("SendKeyDelay", 60)
            MouseClick("left" , 369,545 , 3); Schlagwörter
            Sleep(Random(1000, 1500, 1))
            send($_readJ); 1 Design, Hashtag 1
            Sleep(Random(300, 1900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readK); 1 Design, Hashtag 2
            Sleep(Random(300, 1900, 1))
            send("{SPACE}")
            Sleep(Random(600, 900, 1))
            send($_readL); 1 Design, Hashtag 3
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readM); 1 Design, Hashtag 4
            Sleep(Random(800, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readN); 1 Design, Hashtag 5
            Sleep(Random(300, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 700, 1))
            send($_readO); 1 Design, Hashtag 6
            Sleep(Random(500, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readP); 1 Design, Hashtag 7
            Sleep(Random(300, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readQ); 1 Design, Hashtag 8
            Sleep(Random(600, 2900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            send($_readR); 1 Design, Hashtag 9
            Sleep(Random(300, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 3900, 1))
            send($_readS); 1 Design, Hashtag 10
            Sleep(Random(300, 900, 1))
            send("{SPACE}")
            Sleep(Random(300, 900, 1))
            MouseClick("left" , 67,393 , 1); Random
            Sleep(Random(300, 900, 1))
            Send("{END}")
            sleep(1000)
            Send("{PGUP}")
            sleep(1000)
            MouseClick("left" , 306,200 , 1); Erweitert
            Sleep(Random(900, 1400, 1))
            MouseClick("left" , 308,522 , 1); Lizens Text
            Sleep(Random(900, 1400, 1))
            ;send("I created this Design, I load this same Design on other Plattforms.")
            Sleep(Random(900, 1400, 1))
            MouseClick("left" , 403,606 , 2); Computer Dursuchen
            Sleep(Random(100, 500, 1))
            MouseClick("left" , 472,605 , 1); Computer Dursuchen 2
            sleep(100)
            MouseClick("left" , 872,309 , 1); Computer Dursuchen 3
            sleep(100)
            WinSetState("Datei hochladen", "", @SW_MAXIMIZE)
            sleep(1000)
            ;$HWND = WinWaitActive("Datei hochladen", "")
            sleep(2500)
            ControlClick("Datei hochladen", "", "[CLASS:ToolbarWindow32; INSTANCE:3; ID:1001]"); !!!wichtigKlick auf Suchleiste des Ordners ( Datei hochladen),markiert diesen automatisch
            Sleep(Random(900, 3400, 1))
            send("{backspace}") ; löschen
            Sleep(Random(900, 1400, 1))
            Opt("SendKeyDelay", 20)
            Select
                Case $_readH = 1
                    send("C:\Users\PPPP\Desktop\Sd")
                Case Else
                    send("C:\Users\PPPPP\Desktop\Sd")
            EndSelect
            sleep(1000)
            send("{ENTER}")
            sleep(2000)
            ;Send("{^a}")
            MouseClick("left" , 666,384 , 2)
            sleep(1000)
            MouseClick("left" , 424,363 , 2)
            sleep(3000)
            Send("{CTRLdown}")
            Send("a")
            Send("{CTRLUP}")
            sleep(2500)
            ControlClick("Datei hochladen","", "[CLASS:Button; INSTANCE:1; ID:1]")
            sleep(10000)
            MouseClick("left" , 103,444 , 1)
            sleep(500)
            Send("{END}")
            sleep(1000)
            Send("{PGUP}")
            sleep(500)
            Sleep(Random(1500, 15000, 1))
            MouseClick("left" , 381,425 , 1); veröffentlichen
            Sleep(Random(25000, 30400, 1))
            WinClose("My Saved Designs - Mozilla Firefox", "")
            sleep(3000)
            MouseClick("left" ,1343 ,16 , 1); Klick Manuel auf Seite Schließen, 3 fach sicher     22222
            sleep(2000)
            MouseClick("left" ,897 ,376 , 1) ; Klick auf "Seite verlassen" - Fenster Random         222222222222
            sleep(2000)
        Case Else
            MouseClick("left" ,737 ,554 , 1)
    EndSelect
    #EndRegion
    Alles anzeigen
  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 21. Juli 2020 um 20:56

    Anfänglich ging es ja um ein allgemeines Thema, wir sind dann auf "Func" abgedrifftet. Die Deutsche Anleitung habe ich mir heruntergeladen, leider funktioniert die Suchfunktion nicht ganz, ansonsten lasse ich die englische Version über Google Übersetzer übersetzten. Ich glaube aber aber mit "Func" wird mein vorhaben nicht klappen.
    Ich habe folgendes Skript: mit

    C
    #include <AutoIt>
     
    #Region
    #AutoIt3Wrapper_Au3Check_Parameters=-q -d -w 1 -w 2 -w 3 -w 4 -w 5 -w 6 -w 7
    
    Opt('MustDeclareVars', 1)
    #include <Excel.au3>
    Global $oExcel_1 = _Excel_Open()
    Global $var = "C:\Users\PPPPP\Desktop\Read ideal.xlsx"
    Global $oWorkbook = _Excel_BookOpen($oExcel_1,$var)
    WinActivate("Read ideal - Microsoft Excel")
    sleep(15000)
    
    Global $_readA, $_readB, $_readC,  $_readD,  $_readE, $_readF, $_readG, $_readH, $_readI, $_readJ, $_readK, $_readL, $_readM,  $_readN, $_readO,  $_readP, $_readQ, $_readR,  $_readS, $_readT, $_readU, $_readV, $_readW, $_readX, $_readY,  $_readZ,  $_readAA, $_readAB, $_readAC, $_readAD, $_readAE, $_readAF, $_readAG, $_readAH, $_readAI,  $_readAJ, $_readAK,  $_readAL, $_readAM, $_readAN,  $_readAO, $_readAP, $_readAQ, $_readAR, $_readAS, $_readAT, $_readAU, $_readAV, $_readAW, $_readAX,  $_readAY,  $_readAZ, $_readBA, $_readBB, $_readBC, $_readBD,$_readBE, $_readBF,$_readBG, $_readBH,$iCount, $HWND
    
    
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      ;
    Global $aRanges =        [    ['B2', 'B3', 'B4', 'B5', 'B6', 'B7', 'B8', 'B9', 'B10', 'B11', 'B12', 'B13', 'B14', 'B15', 'B16', 'B17', 'B18', 'B19', 'B20', 'B21', 'B22', 'B23', 'B24', 'B25', 'B26', 'B27', 'B28', 'B29', 'B30', 'B31', 'B32', 'B33', 'B34', 'B35', 'B36', 'B37', 'B38', 'B39', 'B40', 'B41', 'B42', 'B43', 'B44', 'B45', 'B46', 'B47', 'B48', 'B49', 'B50', 'B51', 'B52', 'B53', 'B54', 'B55', 'B56', 'B57','B58','B59','B60','B61'], _
                            ['C2', 'C3', 'C4', 'C5', 'C6', 'C7', 'C8', 'C9', 'C10', 'C11', 'C12', 'C13', 'C14', 'C15', 'C16', 'C17', 'C18', 'C19', 'C20', 'C21', 'C22', 'C23', 'C24', 'C25', 'C26', 'C27', 'C28', 'C29', 'C30', 'C31', 'C32', 'C33', 'C34', 'C35', 'C36', 'C37', 'C38', 'C39', 'C40', 'C41', 'C42', 'C43', 'C44', 'C45', 'C46', 'C47', 'C48', 'C49', 'C50', 'C51', 'C52', 'C53', 'C54', 'C55', 'C56', 'C57', 'C58', 'C59', 'C60','C61'], _
                            [ 'D2', 'D3', 'D4', 'D5', 'D6', 'D7', 'D8', 'D9', 'D10', 'D11', 'D12', 'D13', 'D14', 'D15', 'D16', 'D17', 'D18', 'D19', 'D20', 'D21', 'D22', 'D23', 'D24', 'D25', 'D26', 'D27', 'D28', 'D29', 'D30', 'D31', 'D32', 'D33', 'D34', 'D35', 'D36', 'D37', 'D38', 'D39', 'D40', 'D41', 'D42', 'D43', 'D44', 'D45', 'D46', 'D47', 'D48', 'D49', 'D50', 'D51', 'D52', 'D53', 'D54', 'D55', 'D56', 'D57', 'D58', 'D59', 'D60', 'D61'], _
                            [ 'E2', 'E3', 'E4', 'E5', 'E6', 'E7', 'E8', 'E9', 'E10', 'E11', 'E12', 'E13', 'E14', 'E15', 'E16', 'E17', 'E18', 'E19', 'E20', 'E21', 'E22', 'E23', 'E24', 'E25', 'E26', 'E27', 'E28', 'E29', 'E30', 'E31', 'E32', 'E33', 'E34', 'E35', 'E36', 'E37', 'E38', 'E39', 'E40', 'E41', 'E42', 'E43', 'E44', 'E45', 'E46', 'E47', 'E48', 'E49', 'E50', 'E51', 'E52', 'E53', 'E54', 'E55', 'E56', 'E57', 'E58', 'E59', 'E60', 'E61'], _
                            [ 'F2', 'F3', 'F4', 'F5', 'F6', 'F7', 'F8', 'F9', 'F10', 'F11', 'F12', 'F13', 'F14', 'F15', 'F16', 'F17', 'F18', 'F19', 'F20', 'F21', 'F22', 'F23', 'F24', 'F25', 'F26', 'F27', 'F28', 'F29', 'F30', 'F31', 'F32', 'F33', 'F34', 'F35', 'F36', 'F37', 'F38', 'F39', 'F40', 'F41', 'F42', 'F43', 'F44', 'F45', 'F46', 'F47', 'F48', 'F49', 'F50', 'F51', 'F52', 'F53', 'F54', 'F55', 'F56', 'F57', 'F58', 'F59', 'F60', 'F61'], _
                            [ 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9', 'G10', 'G11', 'G12', 'G13', 'G14', 'G15', 'G16', 'G17', 'G18', 'G19', 'G20', 'G21', 'G22', 'G23', 'G24', 'G25', 'G26', 'G27', 'G28', 'G29', 'G30', 'G31', 'G32', 'G33', 'G34', 'G35', 'G36', 'G37', 'G38', 'G39', 'G40', 'G41', 'G42', 'G43', 'G44', 'G45', 'G46', 'G47', 'G48', 'G49', 'G50', 'G51', 'G52', 'G53', 'G54', 'G55', 'G56', 'G57', 'G58', 'G59', 'G60', 'G61'], _
                            [ 'H2', 'H3', 'H4', 'H5', 'H6', 'H7', 'H8', 'H9', 'H10', 'H11', 'H12', 'H13', 'H14', 'H15', 'H16', 'H17', 'H18', 'H19', 'H20', 'H21', 'H22', 'H23', 'H24', 'H25', 'H26', 'H27', 'H28', 'H29', 'H30', 'H31', 'H32', 'H33', 'H34', 'H35', 'H36', 'H37', 'H38', 'H39', 'H40', 'H41', 'H42', 'H43', 'H44', 'H45', 'H46', 'H47', 'H48', 'H49', 'H50', 'H51', 'H52', 'H53', 'H54', 'H55', 'H56', 'H57', 'H58', 'H59', 'H60', 'H61'], _
                            [ 'I2', 'I3', 'I4', 'I5', 'I6', 'I7', 'I8', 'I9', 'I10', 'I11', 'I12', 'I13', 'I14', 'I15', 'I16', 'I17', 'I18', 'I19', 'I20', 'I21', 'I22', 'I23', 'I24', 'I25', 'I26', 'I27', 'I28', 'I29', 'I30', 'I31', 'I32', 'I33', 'I34', 'I35', 'I36', 'I37', 'I38', 'I39', 'I40', 'I41', 'I42', 'I43', 'I44', 'I45', 'I46', 'I47', 'I48', 'I49', 'I50', 'I51', 'I52', 'I53', 'I54', 'I55', 'I56', 'I57', 'I58', 'I59', 'I60', 'I61'], _
                            [ 'J2', 'J3', 'J4', 'J5', 'J6', 'J7', 'J8', 'J9', 'J10', 'J11', 'J12', 'J13', 'J14', 'J15', 'J16', 'J17', 'J18', 'J19', 'J20', 'J21', 'J22', 'J23', 'J24', 'J25', 'J26', 'J27', 'J28', 'J29', 'J30', 'J31', 'J32', 'J33', 'J34', 'J35', 'J36', 'J37', 'J38', 'J39', 'J40', 'J41', 'J42', 'J43', 'J44', 'J45', 'J46', 'J47', 'J48', 'J49', 'J50', 'J51', 'J52', 'J53', 'J54', 'J55', 'J56', 'J57', 'J58', 'J59', 'J60', 'J61'], _
                            [ 'K2', 'K3', 'K4', 'K5', 'K6', 'K7', 'K8', 'K9', 'K10', 'K11', 'K12', 'K13', 'K14', 'K15', 'K16', 'K17', 'K18', 'K19', 'K20', 'K21', 'K22', 'K23', 'K24', 'K25', 'K26', 'K27', 'K28', 'K29', 'K30', 'K31', 'K32', 'K33', 'K34', 'K35', 'K36', 'K37', 'K38', 'K39', 'K40', 'K41', 'K42', 'K43', 'K44', 'K45', 'K46', 'K47', 'K48', 'K49', 'K50', 'K51', 'K52', 'K53', 'K54', 'K55', 'K56', 'K57', 'K58', 'K59', 'K60', 'K61'], _
                            [ 'L2', 'L3', 'L4', 'L5', 'L6', 'L7', 'L8', 'L9', 'L10', 'L11', 'L12', 'L13', 'L14', 'L15', 'L16', 'L17', 'L18', 'L19', 'L20', 'L21', 'L22', 'L23', 'L24', 'L25', 'L26', 'L27', 'L28', 'L29', 'L30', 'L31', 'L32', 'L33', 'L34', 'L35', 'L36', 'L37', 'L38', 'L39', 'L40', 'L41', 'L42', 'L43', 'L44', 'L45', 'L46', 'L47', 'L48', 'L49', 'L50', 'L51', 'L52', 'L53', 'L54', 'L55', 'L56', 'L57', 'L58', 'L59', 'L60', 'L61'], _
                            [ 'M2', 'M3', 'M4', 'M5', 'M6', 'M7', 'M8', 'M9', 'M10', 'M11', 'M12', 'M13', 'M14', 'M15', 'M16', 'M17', 'M18', 'M19', 'M20', 'M21', 'M22', 'M23', 'M24', 'M25', 'M26', 'M27', 'M28', 'M29', 'M30', 'M31', 'M32', 'M33', 'M34', 'M35', 'M36', 'M37', 'M38', 'M39', 'M40', 'M41', 'M42', 'M43', 'M44', 'M45', 'M46', 'M47', 'M48', 'M49', 'M50', 'M51', 'M52', 'M53', 'M54', 'M55', 'M56', 'M57', 'M58', 'M59', 'M60', 'M61'], _
                            [ 'N2', 'N3', 'N4', 'N5', 'N6', 'N7', 'N8', 'N9', 'N10', 'N11', 'N12', 'N13', 'N14', 'N15', 'N16', 'N17', 'N18', 'N19', 'N20', 'N21', 'N22', 'N23', 'N24', 'N25', 'N26', 'N27', 'N28', 'N29', 'N30', 'N31', 'N32', 'N33', 'N34', 'N35', 'N36', 'N37', 'N38', 'N39', 'N40', 'N41', 'N42', 'N43', 'N44', 'N45', 'N46', 'N47', 'N48', 'N49', 'N50', 'N51', 'N52', 'N53', 'N54', 'N55', 'N56', 'N57', 'N58', 'N59', 'N60', 'N61'], _
                            [ 'O2', 'O3', 'O4', 'O5', 'O6', 'O7', 'O8', 'O9', 'O10', 'O11', 'O12', 'O13', 'O14', 'O15', 'O16', 'O17', 'O18', 'O19', 'O20', 'O21', 'O22', 'O23', 'O24', 'O25', 'O26', 'O27', 'O28', 'O29', 'O30', 'O31', 'O32', 'O33', 'O34', 'O35', 'O36', 'O37', 'O38', 'O39', 'O40', 'O41', 'O42', 'O43', 'O44', 'O45', 'O46', 'O47', 'O48', 'O49', 'O50', 'O51', 'O52', 'O53', 'O54', 'O55', 'O56', 'O57', 'O58', 'O59', 'O60', 'O61'], _
                            [ 'P2', 'P3', 'P4', 'P5', 'P6', 'P7', 'P8', 'P9', 'P10', 'P11', 'P12', 'P13', 'P14', 'P15', 'P16', 'P17', 'P18', 'P19', 'P20', 'P21', 'P22', 'P23', 'P24', 'P25', 'P26', 'P27', 'P28', 'P29', 'P30', 'P31', 'P32', 'P33', 'P34', 'P35', 'P36', 'P37', 'P38', 'P39', 'P40', 'P41', 'P42', 'P43', 'P44', 'P45', 'P46', 'P47', 'P48', 'P49', 'P50', 'P51', 'P52', 'P53', 'P54', 'P55', 'P56', 'P57', 'P58', 'P59', 'P60', 'P61'], _
                            [ 'Q2', 'Q3', 'Q4', 'Q5', 'Q6', 'Q7', 'Q8', 'Q9', 'Q10', 'Q11', 'Q12', 'Q13', 'Q14', 'Q15', 'Q16', 'Q17', 'Q18', 'Q19', 'Q20', 'Q21', 'Q22', 'Q23', 'Q24', 'Q25', 'Q26', 'Q27', 'Q28', 'Q29', 'Q30', 'Q31', 'Q32', 'Q33', 'Q34', 'Q35', 'Q36', 'Q37', 'Q38', 'Q39', 'Q40', 'Q41', 'Q42', 'Q43', 'Q44', 'Q45', '46', 'Q47', 'Q48', 'Q49', 'Q50', 'Q51', 'Q52', 'Q53', 'Q54', 'Q55', 'Q56', 'Q57', 'Q58', 'Q59', 'Q60', 'Q61'], _
                            [ 'R2', 'R3', 'R4', 'R5', 'R6', 'R7', 'R8', 'R9', 'R10', 'R11', 'R12', 'R13', 'R14', 'R15', 'R16', 'R17', 'R18', 'R19', 'R20', 'R21', 'R22', 'R23', 'R24', 'R25', 'R26', 'R27', 'R28', 'R29', 'R30', 'R31', 'R32', 'R33', 'R34', 'R35', 'R36', 'R37', 'R38', 'R39', 'R40', 'R41', 'R42', 'R43', 'R44', 'R45', 'R46', 'R47', 'R48', 'R49', 'R50', 'R51', 'R52', 'R53', 'R54', 'R55', 'R56', 'R57', 'R58', 'R59', 'R60', 'R61'], _
                            [ 'S2', 'S3', 'S4', 'S5', 'S6', 'S7', 'S8', 'S9', 'S10', 'S11', 'S12', 'S13', 'S14', 'S15', 'S16', 'S17', 'S18', 'S19', 'S20', 'S21', 'S22', 'S23', 'S24', 'S25', 'S26', 'S27', 'S28', 'S29', 'S30', 'S31', 'S32', 'S33', 'S34', 'S35', 'S36', 'S37', 'S38', 'S39', 'S40', 'S41', 'S42', 'S43', 'S44', 'S45', 'S46', 'S47', 'S48', 'S49', 'S50', 'S51', 'S52', 'S53', 'S54', 'S55', 'S56', 'S57', 'S58', 'S59', 'S60', 'S61'], _
                            [ 'T2', 'T3', 'T4', 'T5', 'T6', 'T7', 'T8', 'T9', 'T10', 'T11', 'T12', 'T13', 'T14', 'T15', 'T16', 'T17', 'T18', 'T19', 'T20', 'T21', 'T22', 'T23', 'T24', 'T25', 'T26', 'T27', 'T28', 'T29', 'T30', 'T31', 'T32', 'T33', 'T34', 'T35', 'T36', 'T37', 'T38', 'T39', 'T40', 'T41', 'T42', 'T43', 'T44', 'T45', 'T46', 'T47', 'T48', 'T49', 'T50', 'T51', 'T52', 'T53', 'T54', 'T55', 'T56', 'T57', 'T58', 'T59', 'T60', 'T61'], _
                            [ 'U2', 'U3', 'U4', 'U5', 'U6', 'U7', 'U8', 'U9', 'U10', 'U11', 'U12', 'U13', 'U14', 'U15', 'U16', 'U17', 'U18', 'U19', 'U20', 'U21', 'U22', 'U23', 'U24', 'U25', 'U26', 'U27', 'U28', 'U29', 'U30', 'U31', 'U32', 'U33', 'U34', 'U35', 'U36', 'U37', 'U38', 'U39', 'U40', 'U41', 'U42', 'U43', 'U44', 'U45', 'U46', 'U47', 'U48', 'U49', 'U50', 'U51', 'U52', 'U53', 'U54', 'U55', 'U56', 'U57', 'U58', 'U59', 'U60', 'U61'], _
                            [ 'V2', 'V3', 'V4', 'V5', 'V6', 'V7', 'V8', 'V9', 'V10', 'V11', 'V12', 'V13', 'V14', 'V15', 'V16', 'V17', 'V18', 'V19', 'V20', 'V21', 'V22', 'V23', 'V24', 'V25', 'V26', 'V27', 'V28', 'V29', 'V30', 'V31', 'V32', 'V33', 'V34', 'V35', 'V36', 'V37', 'V38', 'V39', 'V40', 'V41', 'V42', 'V43', 'V44', 'V45', 'V46', 'V47', 'V48', 'V49', 'V50', 'V51', 'V52', 'V53', 'V54', 'V55', 'V56', 'V57', 'V58', 'V59', 'V60', 'V61'], _
                            [ 'W2', 'W3', 'W4', 'W5', 'W6', 'W7', 'W8', 'W9', 'W10', 'W11', 'W12', 'W13', 'W14', 'W15', 'W16', 'W17', 'W18', 'W19', 'W20', 'W21', 'W22', 'W23', 'W24', 'W25', 'W26', 'W27', 'W28', 'W29', 'W30', 'W31', 'W32', 'W33', 'W34', 'W35', 'W36', 'W37', 'W38', 'W39', 'W40', 'W41', 'W42', 'W43', 'W44', 'W45', 'W46', 'W47', 'W48', 'W49', 'W50', 'W51', 'W52', 'W53', 'W54', 'W55', 'W56', 'W57', 'W58', 'W59', 'W60', 'W61'], _
                            [ 'X2', 'X3', 'X4', 'X5', 'X6', 'X7', 'X8', 'X9', 'X10', 'X11', 'X12', 'X13', 'X14', 'X15', 'X16', 'X17', 'X18', 'X19', 'X20', 'X21', 'X22', 'X23', 'X24', 'X25', 'X26', 'X27', 'X28', 'X29', 'X30', 'X31', 'X32', 'X33', 'X34', 'X35', 'X36', 'X37', 'X38', 'X39', 'X40', 'X41', 'X42', 'X43', 'X44', 'X45', 'X46', 'X47', 'X48', 'X49', 'X50', 'X51', 'X52', 'X53', 'X54', 'X55', 'X56', 'X57', 'X58', 'X59', 'X60', 'X61'], _
                            [ 'Y2', 'Y3', 'Y4', 'Y5', 'Y6', 'Y7', 'Y8', 'Y9', 'Y10', 'Y11', 'Y12', 'Y13', 'Y14', 'Y15', 'Y16', 'Y17', 'Y18', 'Y19', 'Y20', 'Y21', 'Y22', 'Y23', 'Y24', 'Y25', 'Y26', 'Y27', 'Y28', 'Y29', 'Y30', 'Y31', 'Y32', 'Y33', 'Y34', 'Y35', 'Y36', 'Y37', 'Y38', 'Y39', 'Y40', 'Y41', 'Y42', 'Y43', 'Y44', 'Y45', 'Y46', 'Y47', 'Y48', 'Y49', 'Y50', 'Y51', 'Y52', 'Y53', 'Y54', 'Y55', 'Y56', 'Y57', 'Y58', 'Y59', 'Y60', 'Y61'], _
                            [ 'Z2', 'Z3', 'Z4', 'Z5', 'Z6', 'Z7', 'Z8', 'Z9', 'Z10', 'Z11', 'Z12', 'Z13', 'Z14', 'Z15', 'Z16', 'Z17', 'Z18', 'Z19', 'Z20', 'Z21', 'Z22', 'Z23', 'Z24', 'Z25', 'Z26', 'Z27', 'Z28', 'Z29', 'Z30', 'Z31', 'Z32', 'Z33', 'Z34', 'Z35', 'Z36', 'Z37', 'Z38', 'Z39', 'Z40', 'Z41', 'Z42', 'Z43', 'Z44', 'Z45', 'Z46', 'Z47', 'Z48', 'Z49', 'Z50', 'Z51', 'Z52', 'Z53', 'Z54', 'Z55', 'Z56', 'Z57', 'Z58', 'Z59', 'Z60', 'Z61'], _
                            [ 'AA2', 'AA3', 'AA4', 'AA5', 'AA6', 'AA7', 'AA8', 'AA9', 'AA10', 'AA11', 'AA12', 'AA13', 'AA14', 'AA15', 'AA16', 'AA17', 'AA18', 'AA19', 'AA20', 'AA21', 'AA22', 'AA23', 'AA24', 'AA25', 'AA26', 'AA27', 'AA28', 'AA29', 'AA30', 'AA31', 'AA32', 'AA33', 'AA34', 'AA35', 'AA36', 'AA37', 'AA38', 'AA39', 'AA40', 'AA41', 'AA42', 'AA43', 'AA44', 'AA45', 'AA46', 'AA47', 'AA48', 'AA49', 'AA50', 'AA51', 'AA52', 'AA53', 'AA54', 'AA55', 'AA56', 'AA57', 'AA58', 'AA59', 'AA60', 'AA61'], _
                            [ 'AB2', 'AB3', 'AB4', 'AB5', 'AB6', 'AB7', 'AB8', 'AB9', 'AB10', 'AB11', 'AB12', 'AB13', 'AB14', 'AB15', 'AB16', 'AB17', 'AB18', 'AB19', 'AB20', 'AB21', 'AB22', 'AB23', 'AB24', 'AB25', 'AB26', 'AB27', 'AB28', 'AB29', 'AB30', 'AB31', 'AB32', 'AB33', 'AB34', 'AB35', 'AB36', 'AB37', 'AB38', 'AB39', 'AB40', 'AB41', 'AB42', 'AB43', 'AB44', 'AB45', 'AB46', 'AB47', 'AB48', 'AB49', 'AB50', 'AB51', 'AB52', 'AB53', 'AB54', 'AB55', 'AB56', 'AB57', 'AB58', 'AB59', 'AB60', 'AB61'], _
                            [ 'AC2', 'AC3', 'AC4', 'AC5', 'AC6', 'AC7', 'AC8', 'AC9', 'AC10', 'AC11', 'AC12', 'AC13', 'AC14', 'AC15', 'AC16', 'AC17', 'AC18', 'AC19', 'AC20', 'AC21', 'AC22', 'AC23', 'AC24', 'AC25', 'AC26', 'AC27', 'AC28', 'AC29', 'AC30', 'AC31', 'AC32', 'AC33', 'AC34', 'AC35', 'AC36', 'AC37', 'AC38', 'AC39', 'AC40', 'AC41', 'AC42', 'AC43', 'AC44', 'AC45', 'AC46', 'AC47', 'AC48', 'AC49', 'AC50', 'AC51', 'AC52', 'AC53', 'AC54', 'AC55', 'AC56', 'AC57', 'AC58', 'AC59', 'AC60', 'AC61'], _
                            [ 'AD2', 'AD3', 'AD4', 'AD5', 'AD6', 'AD7', 'AD8', 'AD9', 'AD10', 'AD11', 'AD12', 'AD13', 'AD14', 'AD15', 'AD16', 'AD17', 'AD18', 'AD19', 'AD20', 'AD21', 'AD22', 'AD23', 'AD24', 'AD25', 'AD26', 'AD27', 'AD28', 'AD29', 'AD30', 'AD31', 'AD32', 'AD33', 'AD34', 'AD35', 'AD36', 'AD37', 'AD38', 'AD39', 'AD40', 'AD41', 'AD42', 'AD43', 'AD44', 'AD45', 'AD46', 'AD47', 'AD48', 'AD49', 'AD50', 'AD51', 'AD52', 'AD53', 'AD54', 'AD55', 'AD56', 'AD57', 'AD58', 'AD59', 'AD60', 'AD61'], _
                            [ 'AE2', 'AE3', 'AE4', 'AE5', 'AE6', 'AE7', 'AE8', 'AE9', 'AE10', 'AE11', 'AE12', 'AE13', 'AE14', 'AE15', 'AE16', 'AE17', 'AE18', 'AE19', 'AE20', 'AE21', 'AE22', 'AE23', 'AE24', 'AE25', 'AE26', 'AE27', 'AE28', 'AE29', 'AE30', 'AE31', 'AE32', 'AE33', 'AE34', 'AE35', 'AE36', 'AE37', 'AE38', 'AE39', 'AE40', 'AE41', 'AE42', 'AE43', 'AE44', 'AE45', 'AE46', 'AE47', 'AE48', 'AE49', 'AE50', 'AE51', 'AE52', 'AE53', 'AE54', 'AE55', 'AE56', 'AE57', 'AE58', 'AE59', 'AE60', 'AE61'], _
                            [ 'AF2', 'AF3', 'AF4', 'AF5', 'AF6', 'AF7', 'AF8', 'AF9', 'AF10', 'AF11', 'AF12', 'AF13', 'AF14', 'AF15', 'AF16', 'AF17', 'AF18', 'AF19', 'AF20', 'AF21', 'AF22', 'AF23', 'AF24', 'AF25', 'AF26', 'AF27', 'AF28', 'AF29', 'AF30', 'AF31', 'AF32', 'AF33', 'AF34', 'AF35', 'AF36', 'AF37', 'AF38', 'AF39', 'AF40', 'AF41', 'AF42', 'AF43', 'AF44', 'AF45', 'AF46', 'AF47', 'AF48', 'AF49', 'AF50', 'AF51', 'AF52', 'AF53', 'AF54', 'AF55', 'AF56', 'AF57', 'AF58', 'AF59', 'AF60', 'AF61'], _
                            [ 'AG2', 'AG3', 'AG4', 'AG5', 'AG6', 'AG7', 'AG8', 'AG9', 'AG10', 'AG11', 'AG12', 'AG13', 'AG14', 'AG15', 'AG16', 'AG17', 'AG18', 'AG19', 'AG20', 'AG21', 'AG22', 'AG23', 'AG24', 'AG25', 'AG26', 'AG27', 'AG28', 'AG29', 'AG30', 'AG31', 'AG32', 'AG33', 'AG34', 'AG35', 'AG36', 'AG37', 'AG38', 'AG39', 'AG40', 'AG41', 'AG42', 'AG43', 'AG44', 'AG45', 'AG46', 'AG47', 'AG48', 'AG49', 'AG50', 'AG51', 'AG52', 'AG53', 'AG54', 'AG55', 'AG56', 'AG57', 'AG58', 'AG59', 'AG60', 'AG61'], _
                            [ 'AH2', 'AH3', 'AH4', 'AH5', 'AH6', 'AH7', 'AH8', 'AH9', 'AH10', 'AH11', 'AH12', 'AH13', 'AH14', 'AH15', 'AH16', 'AH17', 'AH18', 'AH19', 'AH20', 'AH21', 'AH22', 'AH23', 'AH24', 'AH25', 'AH26', 'AH27', 'AH28', 'AH29', 'AH30', 'AH31', 'AH32', 'AH33', 'AH34', 'AH35', 'AH36', 'AH37', 'AH38', 'AH39', 'AH40', 'AH41', 'AH42', 'AH43', 'AH44', 'AH45', 'AH46', 'AH47', 'AH48', 'AH49', 'AH50', 'AH51', 'AH52', 'AH53', 'AH54', 'AH55', 'AH56', 'AH57', 'AH58', 'AH59', 'AH60', 'AH61'], _
                            [ 'AI2', 'AI3', 'AI4', 'AI5', 'AI6', 'AI7', 'AI8', 'AI9', 'AI10', 'AI11', 'AI12', 'AI13', 'AI14', 'AI15', 'AI16', 'AI17', 'AI18', 'AI19', 'AI20', 'AI21', 'AI22', 'AI23', 'AI24', 'AI25', 'AI26', 'AI27', 'AI28', 'AI29', 'AI30', 'AI31', 'AI32', 'AI33', 'AI34', 'AI35', 'AI36', 'AI37', 'AI38', 'AI39', 'AI40', 'AI41', 'AI42', 'AI43', 'AI44', 'AI45', 'AI46', 'AI47', 'AI48', 'AI49', 'AI50', 'AI51', 'AI52', 'AI53', 'AI54', 'AI55', 'AI56', 'AI57', 'AI58', 'AI59', 'AI60', 'AI61'], _
                            [ 'AJ2', 'AJ3', 'AJ4', 'AJ5', 'AJ6', 'AJ7', 'AJ8', 'AJ9', 'AJ10', 'AJ11', 'AJ12', 'AJ13', 'AJ14', 'AJ15', 'AJ16', 'AJ17', 'AJ18', 'AJ19', 'AJ20', 'AJ21', 'AJ22', 'AJ23', 'AJ24', 'AJ25', 'AJ26', 'AJ27', 'AJ28', 'AJ29', 'AJ30', 'AJ31', 'AJ32', 'AJ33', 'AJ34', 'AJ35', 'AJ36', 'AJ37', 'AJ38', 'AJ39', 'AJ40', 'AJ41', 'AJ42', 'AJ43', 'AJ44', 'AJ45', 'AJ46', 'AJ47', 'AJ48', 'AJ49', 'AJ50', 'AJ51', 'AJ52', 'AJ53', 'AJ54', 'AJ55', 'AJ56', 'AJ57', 'AJ58', 'AJ59', 'AJ60', 'AJ61'], _
                            [ 'AK2', 'AK3', 'AK4', 'AK5', 'AK6', 'AK7', 'AK8', 'AK9', 'AK10', 'AK11', 'AK12', 'AK13', 'AK14', 'AK15', 'AK16', 'AK17', 'AK18', 'AK19', 'AK20', 'AK21', 'AK22', 'AK23', 'AK24', 'AK25', 'AK26', 'AK27', 'AK28', 'AK29', 'AK30', 'AK31', 'AK32', 'AK33', 'AK34', 'AK35', 'AK36', 'AK37', 'AK38', 'AK39', 'AK40', 'AK41', 'AK42', 'AK43', 'AK44', 'AK45', 'AK46', 'AK47', 'AK48', 'AK49', 'AK50', 'AK51', 'AK52', 'AK53', 'AK54', 'AK55', 'AK56', 'AK57', 'AK58', 'AK59', 'AK60', 'AK61'], _
                            [ 'AL2', 'AL3', 'AL4', 'AL5', 'AL6', 'AL7', 'AL8', 'AL9', 'AL10', 'AL11', 'AL12', 'AL13', 'AL14', 'AL15', 'AL16', 'AL17', 'AL18', 'AL19', 'AL20', 'AL21', 'AL22', 'AL23', 'AL24', 'AL25', 'AL26', 'AL27', 'AL28', 'AL29', 'AL30', 'AL31', 'AL32', 'AL33', 'AL34', 'AL35', 'AL36', 'AL37', 'AL38', 'AL39', 'AL40', 'AL41', 'AL42', 'AL43', 'AL44', 'AL45', 'AL46', 'AL47', 'AL48', 'AL49', 'AL50', 'AL51', 'AL52', 'AL53', 'AL54', 'AL55', 'AL56', 'AL57', 'AL58', 'AL59', 'AL60', 'AL61'], _
                            [ 'AM2', 'AM3', 'AM4', 'AM5', 'AM6', 'AM7', 'AM8', 'AM9', 'AM10', 'AM11', 'AM12', 'AM13', 'AM14', 'AM15', 'AM16', 'AM17', 'AM18', 'AM19', 'AM20', 'AM21', 'AM22', 'AM23', 'AM24', 'AM25', 'AM26', 'AM27', 'AM28', 'AM29', 'AM30', 'AM31', 'AM32', 'AM33', 'AM34', 'AM35', 'AM36', 'AM37', 'AM38', 'AM39', 'AM40', 'AM41', 'AM42', 'AM43', 'AM44', 'AM45', 'AM46', 'AM47', 'AM48', 'AM49', 'AM50', 'AM51', 'AM52', 'AM53', 'AM54', 'AM55', 'AM56', 'AM57', 'AM58', 'AM59', 'AM60', 'AM61'], _
                            [ 'AN2', 'AN3', 'AN4', 'AN5', 'AN6', 'AN7', 'AN8', 'AN9', 'AN10', 'AN11', 'AN12', 'AN13', 'AN14', 'AN15', 'AN16', 'AN17', 'AN18', 'AN19', 'AN20', 'AN21', 'AN22', 'AN23', 'AN24', 'AN25', 'AN26', 'AN27', 'AN28', 'AN29', 'AN30', 'AN31', 'AN32', 'AN33', 'AN34', 'AN35', 'AN36', 'AN37', 'AN38', 'AN39', 'AN40', 'AN41', 'AN42', 'AN43', 'AN44', 'AN45', 'AN46', 'AN47', 'AN48', 'AN49', 'AN50', 'AN51', 'AN52', 'AN53', 'AN54', 'AN55', 'AN56', 'AN57', 'AN58', 'AN59', 'AN60', 'AN61'], _
                            [ 'AO2', 'AO3', 'AO4', 'AO5', 'AO6', 'AO7', 'AO8', 'AO9', 'AO10', 'AO11', 'AO12', 'AO13', 'AO14', 'AO15', 'AO16', 'AO17', 'AO18', 'AO19', 'AO20', 'AO21', 'AO22', 'AO23', 'AO24', 'AO25', 'AO26', 'AO27', 'AO28', 'AO29', 'AO30', 'AO31', 'AO32', 'AO33', 'AO34', 'AO35', 'AO36', 'AO37', 'AO38', 'AO39', 'AO40', 'AO41', 'AO42', 'AO43', 'AO44', 'AO45', 'AO46', 'AO47', 'AO48', 'AO49', 'AO50', 'AO51', 'AO52', 'AO53', 'AO54', 'AO55', 'AO56', 'AO57', 'AO58', 'AO59', 'AO60', 'AO61'], _
                            [ 'AP2', 'AP3', 'AP4', 'AP5', 'AP6', 'AP7', 'AP8', 'AP9', 'AP10', 'AP11', 'AP12', 'AP13', 'AP14', 'AP15', 'AP16', 'AP17', 'AP18', 'AP19', 'AP20', 'AP21', 'AP22', 'AP23', 'AP24', 'AP25', 'AP26', 'AP27', 'AP28', 'AP29', 'AP30', 'AP31', 'AP32', 'AP33', 'AP34', 'AP35', 'AP36', 'AP37', 'AP38', 'AP39', 'AP40', 'AP41', 'AP42', 'AP43', 'AP44', 'AP45', 'AP46', 'AP47', 'AP48', 'AP49', 'AP50', 'AP51', 'AP52', 'AP53', 'AP54', 'AP55', 'AP56', 'AP57', 'AP58', 'AP59', 'AP60', 'AP61'], _
                            [ 'AQ2', 'AQ3', 'AQ4', 'AQ5', 'AQ6', 'AQ7', 'AQ8', 'AQ9', 'AQ10', 'AQ11', 'AQ12', 'AQ13', 'AQ14', 'AQ15', 'AQ16', 'AQ17', 'AQ18', 'AQ19', 'AQ20', 'AQ21', 'AQ22', 'AQ23', 'AQ24', 'AQ25', 'AQ26', 'AQ27', 'AQ28', 'AQ29', 'AQ30', 'AQ31', 'AQ32', 'AQ33', 'AQ34', 'AQ35', 'AQ36', 'AQ37', 'AQ38', 'AQ39', 'AQ40', 'AQ41', 'AQ42', 'AQ43', 'AQ44', 'AQ45', 'AQ46', 'AQ47', 'AQ48', 'AQ49', 'AQ50', 'AQ51', 'AQ52', 'AQ53', 'AQ54', 'AQ55', 'AQ56', 'AQ57', 'AQ58', 'AQ59', 'AQ60', 'AQ61'], _
                            [ 'AR2', 'AR3', 'AR4', 'AR5', 'AR6', 'AR7', 'AR8', 'AR9', 'AR10', 'AR11', 'AR12', 'AR13', 'AR14', 'AR15', 'AR16', 'AR17', 'AR18', 'AR19', 'AR20', 'AR21', 'AR22', 'AR23', 'AR24', 'AR25', 'AR26', 'AR27', 'AR28', 'AR29', 'AR30', 'AR31', 'AR32', 'AR33', 'AR34', 'AR35', 'AR36', 'AR37', 'AR38', 'AR39', 'AR40', 'AR41', 'AR42', 'AR43', 'AR44', 'AR45', 'AR46', 'AR47', 'AR48', 'AR49', 'AR50', 'AR51', 'AR52', 'AR53', 'AR54', 'AR55', 'AR56', 'AR57', 'AR58', 'AR59', 'AR60', 'AR61'], _
                            [ 'AS2', 'AS3', 'AS4', 'AS5', 'AS6', 'AS7', 'AS8', 'AS9', 'AS10', 'AS11', 'AS12', 'AS13', 'AS14', 'AS15', 'AS16', 'AS17', 'AS18', 'AS19', 'AS20', 'AS21', 'AS22', 'AS23', 'AS24', 'AS25', 'AS26', 'AS27', 'AS28', 'AS29', 'AS30', 'AS31', 'AS32', 'AS33', 'AS34', 'AS35', 'AS36', 'AS37', 'AS38', 'AS39', 'AS40', 'AS41', 'AS42', 'AS43', 'AS44', 'AS45', 'AS46', 'AS47', 'AS48', 'AS49', 'AS50', 'AS51', 'AS52', 'AS53', 'AS54', 'AS55', 'AS56', 'AS57', 'AS58', 'AS59', 'AS60', 'AS61'], _
                            [ 'AT2', 'AT3', 'AT4', 'AT5', 'AT6', 'AT7', 'AT8', 'AT9', 'AT10', 'AT11', 'AT12', 'AT13', 'AT14', 'AT15', 'AT16', 'AT17', 'AT18', 'AT19', 'AT20', 'AT21', 'AT22', 'AT23', 'AT24', 'AT25', 'AT26', 'AT27', 'AT28', 'AT29', 'AT30', 'AT31', 'AT32', 'AT33', 'AT34', 'AT35', 'AT36', 'AT37', 'AT38', 'AT39', 'AT40', 'AT41', 'AT42', 'AT43', 'AT44', 'AT45', 'AT46', 'AT47', 'AT48', 'AT49', 'AT50', 'AT51', 'AT52', 'AT53', 'AT54', 'AT55', 'AT56', 'AT57', 'AT58', 'AT59', 'AT60', 'AT61'], _
                            [ 'AU2', 'AU3', 'AU4', 'AU5', 'AU6', 'AU7', 'AU8', 'AU9', 'AU10', 'AU11', 'AU12', 'AU13', 'AU14', 'AU15', 'AU16', 'AU17', 'AU18', 'AU19', 'AU20', 'AU21', 'AU22', 'AU23', 'AU24', 'AU25', 'AU26', 'AU27', 'AU28', 'AU29', 'AU30', 'AU31', 'AU32', 'AU33', 'AU34', 'AU35', 'AU36', 'AU37', 'AU38', 'AU39', 'AU40', 'AU41', 'AU42', 'AU43', 'AU44', 'AU45', 'AU46', 'AU47', 'AU48', 'AU49', 'AU50', 'AU51', 'AU52', 'AU53', 'AU54', 'AU55', 'AU56', 'AU57', 'AU58', 'AU59', 'AU60', 'AU61'], _
                            [ 'AV2', 'AV3', 'AV4', 'AV5', 'AV6', 'AV7', 'AV8', 'AV9', 'AV10', 'AV11', 'AV12', 'AV13', 'AV14', 'AV15', 'AV16', 'AV17', 'AV18', 'AV19', 'AV20', 'AV21', 'AV22', 'AV23', 'AV24', 'AV25', 'AV26', 'AV27', 'AV28', 'AV29', 'AV30', 'AV31', 'AV32', 'AV33', 'AV34', 'AV35', 'AV36', 'AV37', 'AV38', 'AV39', 'AV40', 'AV41', 'AV42', 'AV43', 'AV44', 'AV45', 'AV46', 'AV47', 'AV48', 'AV49', 'AV50', 'AV51', 'AV52', 'AV53', 'AV54', 'AV55', 'AV56', 'AV57', 'AV58', 'AV59', 'AV60', 'AV61'], _
                            [ 'AW2', 'AW3', 'AW4', 'AW5', 'AW6', 'AW7', 'AW8', 'AW9', 'AW10', 'AW11', 'AW12', 'AW13', 'AW14', 'AW15', 'AW16', 'AW17', 'AW18', 'AW19', 'AW20', 'AW21', 'AW22', 'AW23', 'AW24', 'AW25', 'AW26', 'AW27', 'AW28', 'AW29', 'AW30', 'AW31', 'AW32', 'AW33', 'AW34', 'AW35', 'AW36', 'AW37', 'AW38', 'AW39', 'AW40', 'AW41', 'AW42', 'AW43', 'AW44', 'AW45', 'AW46', 'AW47', 'AW48', 'AW49', 'AW50', 'AW51', 'AW52', 'AW53', 'AW54', 'AW55', 'AW56', 'AW57', 'AW58', 'AW59', 'AW60', 'AW61'], _
                            [ 'AX2', 'AX3', 'AX4', 'AX5', 'AX6', 'AX7', 'AX8', 'AX9', 'AX10', 'AX11', 'AX12', 'AX13', 'AX14', 'AX15', 'AX16', 'AX17', 'AX18', 'AX19', 'AX20', 'AX21', 'AX22', 'AX23', 'AX24', 'AX25', 'AX26', 'AX27', 'AX28', 'AX29', 'AX30', 'AX31', 'AX32', 'AX33', 'AX34', 'AX35', 'AX36', 'AX37', 'AX38', 'AX39', 'AX40', 'AX41', 'AX42', 'AX43', 'AX44', 'AX45', 'AX46', 'AX47', 'AX48', 'AX49', 'AX50', 'AX51', 'AX52', 'AX53', 'AX54', 'AX55', 'AX56', 'AX57', 'AX58', 'AX59', 'AX60', 'AX61'], _
                            [ 'AY2', 'AY3', 'AY4', 'AY5', 'AY6', 'AY7', 'AY8', 'AY9', 'AY10', 'AY11', 'AY12', 'AY13', 'AY14', 'AY15', 'AY16', 'AY17', 'AY18', 'AY19', 'AY20', 'AY21', 'AY22', 'AY23', 'AY24', 'AY25', 'AY26', 'AY27', 'AY28', 'AY29', 'AY30', 'AY31', 'AY32', 'AY33', 'AY34', 'AY35', 'AY36', 'AY37', 'AY38', 'AY39', 'AY40', 'AY41', 'AY42', 'AY43', 'AY44', 'AY45', 'AY46', 'AY47', 'AY48', 'AY49', 'AY50', 'AY51', 'AY52', 'AY53', 'AY54', 'AY55', 'AY56', 'AY57', 'AY58', 'AY59', 'AY60', 'AY61'], _
                            [ 'AZ2', 'AZ3', 'AZ4', 'AZ5', 'AZ6', 'AZ7', 'AZ8', 'AZ9', 'AZ10', 'AZ11', 'AZ12', 'AZ13', 'AZ14', 'AZ15', 'AZ16', 'AZ17', 'AZ18', 'AZ19', 'AZ20', 'AZ21', 'AZ22', 'AZ23', 'AZ24', 'AZ25', 'AZ26', 'AZ27', 'AZ28', 'AZ29', 'AZ30', 'AZ31', 'AZ32', 'AZ33', 'AZ34', 'AZ35', 'AZ36', 'AZ37', 'AZ38', 'AZ39', 'AZ40', 'AZ41', 'AZ42', 'AZ43', 'AZ44', 'AZ45', 'AZ46', 'AZ47', 'AZ48', 'AZ49', 'AZ50', 'AZ51', 'AZ52', 'AZ53', 'AZ54', 'AZ55', 'AZ56', 'AZ57', 'AZ58', 'AZ59', 'AZ60', 'AZ61'] _
                            ]
    
    For $i = 4 To 14 Step 1
    $_readA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][0])
    $_readB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][1])
    $_readC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][2])
    $_readD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][3])
    $_readE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][4])
    $_readF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][5])
    $_readG = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][6])
    $_readH = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][7])
    $_readI = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][8])
    $_readJ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][9])
    $_readK = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][10])
    $_readL = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][11])
    $_readM = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][12])
    $_readN = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][13])
    $_readO = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][14])
    $_readP = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][15])
    $_readQ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][16])
    $_readR = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][17])
    $_readS = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][18])
    $_readT = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][19])
    $_readU = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][20])
    $_readV = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][21])
    $_readW = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][22])
    $_readX = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][23])
    $_readY = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][24])
    $_readZ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][25])
    $_readAA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][26])
    $_readAB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][27])
    $_readAC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][28])
    $_readAD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][29])
    $_readAE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][30])
    $_readAF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][31])
    $_readAG = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][32])
    $_readAH = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][33])
    $_readAI = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][34])
    $_readAJ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][35])
    $_readAK = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][36])
    $_readAL = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][37])
    $_readAM = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][38])
    $_readAN = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][39])
    $_readAO = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][40])
    $_readAP = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][41])
    $_readAQ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][42])
    $_readAR = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][43])
    $_readAS = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][44])
    $_readAT = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][45])
    $_readAU = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][46])
    $_readAV = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][47])
    $_readAW = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][48])
    $_readAX = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][49])
    $_readAY = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][50])
    $_readAZ = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][51])
    $_readBA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][52])
    $_readBB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][53])
    $_readBC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][54])
    $_readBD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][55])
    $_readBE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][56])
    $_readBF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][57])
    $_readBG = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][58])
    $_readBH = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][59])
    
    T_Shirt_Design_hochladen($HWND ,$_readA, $_readB, $_readC,  $_readD,  $_readE, $_readF, $_readG, $_readH, $_readI, $_readJ, $_readK, $_readL, $_readM,  $_readN, $_readO,  $_readP, $_readQ, $_readR,  $_readS, $_readT, $_readU, $_readV, $_readW, $_readX, $_readY,  $_readZ,  $_readAA, $_readAB, $_readAC, $_readAD, $_readAE, $_readAF, $_readAG, $_readAH, $_readAI,  $_readAJ, $_readAK,  $_readAL, $_readAM, $_readAN,  $_readAO, $_readAP, $_readAQ, $_readAR, $_readAS, $_readAT, $_readAU, $_readAV, $_readAW, $_readAX,  $_readAY, $_readBA, $_readBB, $_readBC, $_readBD,$_readBE, $_readBF,$_readBG, $_readBH,$i + 1) ; ($i + 1 = $iCount)
    
    
    Next
    #EndRegion
    
    
    Func T_Shirt_Design_hochladen($HWND,$_readA, $_readB, $_readC,  $_readD,  $_readE, $_readF, $_readG, $_readH, $_readI, $_readJ, $_readK, $_readL, $_readM,  $_readN, $_readO,  $_readP, $_readQ, $_readR,  $_readS, $_readT, $_readU, $_readV, $_readW, $_readX, $_readY,  $_readZ,  $_readAA, $_readAB, $_readAC, $_readAD, $_readAE, $_readAF, $_readAG, $_readAH, $_readAI,  $_readAJ, $_readAK,  $_readAL, $_readAM, $_readAN,  $_readAO, $_readAP, $_readAQ, $_readAR, $_readAS, $_readAT, $_readAU, $_readAV, $_readAW, $_readAX,  $_readAY, $_readBA, $_readBB, $_readBC, $_readBD,$_readBE, $_readBF,$_readBG, $_readBH,$iCount)
    
    
    
    
    #Region Shirt DE
    #EndRegion
    
    
    
    #Region SP.COM
    
    
    #EndRegion
    
    #Region Shir Englisch
    
    #EndRegion
    
    
    #Region Redbubble.com
    
    #EndRegion
    
    
    #Region Shirtee Griechenland
    
    #EndRegion
    
    #Region Shirt Bulgarien
    #EndRegion
    
    
    EndFunc   ;==>T_Shirt_Design_hochladen
    Alles anzeigen

    Mit diesem Skript lade ich Designs auf Plattformen hoch, SP.DE und SP.com sind dabei fast identisch, Für Shirtee Deutsch, Englisch, ... sind auch fast identisch bis auf einen Buchstaben und die Sprache.
    Wenn nun eines dieser PLattformen Änderungen beim Uploadprozess vornimmt, würde ich, wenn möglich, dieses nur einmal im Skript ändern wollen.

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 21. Juli 2020 um 18:26

    Wie würde ich nach den Beispielen von @Musashi und autoiter , dieses auch für eine Reihe von verschiedenen Handlungen hinkriegen? Bspw. EIne Kombination aus sleep´s, Mousclick´s, Controlclick´s,....


    Gruß Bernd

  • Send("{Right " & $iCount & "}") - $iCount in Zweier Schritt ( Step) , unabhängig vom Step der Funktion

    • Bernd Albrecht
    • 20. Juli 2020 um 19:39

    sorry, ich hatte einen Denkfehler, deine Lösung funktioniert wunderbar.

    Code
    #include <AutoIt>
    Send("{Right " & (1+($iCount*2)) & "}")

    Vielen Danke alpines.

  • Send("{Right " & $iCount & "}") - $iCount in Zweier Schritt ( Step) , unabhängig vom Step der Funktion

    • Bernd Albrecht
    • 20. Juli 2020 um 19:33

    Die Schelifenvariable $i kann ich leider nicht nehmen, weil dies meine Funktion "zerstören" würde.

  • Send("{Right " & $iCount & "}") - $iCount in Zweier Schritt ( Step) , unabhängig vom Step der Funktion

    • Bernd Albrecht
    • 20. Juli 2020 um 19:09

    Hallo Leute, ich habe folgende Angelegenenheit und hoffe, das man mir helfen kann:

    Code
    #include <AutoIt>
    Global $aRanges =   [    ['B2', 'B3', 'B4', 'B5'...
    ...
    For $i = 1 To 9 Step 1
    $_readA = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][0])
    $_readB = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][1])
    $_readC = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][2])
    $_readD = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][3])
    $_readE = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][4])
    $_readF = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][5])
    $_readG = _Excel_RangeRead($oWorkbook, Default, $aRanges[$i][6])
    ...
    Send("{Right " & $iCount & "}")
    Alles anzeigen

    Ich möchte, das bei iCount=0 1 mal rechts gedrückt wird, bei iCount= 1 3 mal; bei iCount=2 5; ..... also im zweier Step mit beginn bei 1, aber ich möchte nicht, das dabei auf die Step 3 oder 5 von der Range zugegriffen wird. Also die Lösung Step auf 2 zu stellen, kommt eher nicht in Frage. Gibt es eine Möglichkeit 2 verschiedene Steps innerhalb einer Funktion zu bestimmen?

    Ich danke euch im vorraus für eure Antworten.

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 16. Juli 2020 um 23:44

    nuts müsste

    Zitat von nuts

    _Test() ; erst Ausführung

    ; hier kann wieder was anderes passieren


    _Test() ; zweite Ausführung

    nicht dann nach FUnc _Test() stehen?
    Das ist ein schwirieges Thema oder ich drücke mich nicht verständlich genug aus.
    Vielleicht wäre die bessere Frage: Wofür sind Func/EndFunc gut in AutoIt?

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 16. Juli 2020 um 23:14
    Zitat von Professor Bernd

    Wenn die Bereiche mehrmals exakt so vorkommen, kannst du doch aus allen 1 Funktion machen und an verschiedenen Stellen aufrufen.

    Wie geht das genau? Bei mir kommt eine Fehlermeldung bisher.

    Code
    #include <AutoIt>
    Func Chrome Öffnen
    ShellExecute("chrome.exe", "www.google.de")
    sleep(100)
    ....
    sleep(300)
    EndFunc
    
    Func Chrome Öffnen  ; ( Führe Function "Chrome öffnen" aus)

    2. Beispiel:

    Code
    #include <AutoIt>
            MouseClick("left" , 817,412 , 1); Klick Zum Nächsten Schritt 2
            sleep(7000)
            Send("{END}")
            sleep(1000)
            MouseClick("left" , 24,218 , 1); Random
            sleep(1500)
            Send("{PGUP}")
            sleep(500)
            Send("{PGUP}")
            sleep(1500)
            Send("{PGUP}")
            sleep(500)
            Send("{PGUP}")
            sleep(5000)
    Alles anzeigen

    Diesen Abschnitt würde ich gerne an einer anderen Stelle meines skriptes genau so ausführen wollen, ohne dieses wieder so schreiben zu müssen, wäre es möglich? Ich bin Amateuer. Ich weis beispeilsweise garnicht wofür Func und ENdfunc gut sein soll, ist bsiher für mich fast das gleiche wie #Region und #Endregion....

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 16. Juli 2020 um 22:17

    @Musashi, danke für deine Antwort
    Es gibt doch beispielsweise $HWND = WinWaitActive("Datei hochladen", "") , wenn ich "$HWND" dann später nochmal in meinem Skript verwende brauch ich nicht " WinWaitActive("Datei hochladen", "") " schreiben.

    Ich würde gerne Abschnitte in meinem Skript die identisch mehrmals vorkommen abkürzen wollen, ohne diese immer wieder auszuschreiben. Wenn ich dann beispielsweise mein Skript verändere, bräuchte ich dann, wenn es den möglich sein sollte, nicht jeden bereich einmal verändern sondern nur einen Bereich.
    ich weis nicht wie ich" $HWND" über mehrere Zeilen verwende könnte.

    Gruß Bernd

  • Function / Skriptbereich definieren

    • Bernd Albrecht
    • 16. Juli 2020 um 22:00

    Hallo Leute,

    ich würde gerne bei meinem Skript größere bereiche defnieren die im Skript selbst mehrmals exakt so vorkommen. Sodann würde ich gerne nach dem ich diesen Bereich einmal im Skript zu stehen habe, beim zweiten ( dritten, vierten,...) mal irgendwie kürzen wollen. Ist das bei AuoIt möglich?

    exemplarisch:

    Func Chrome Öffnen und weiteres

    ShellExecute("chrome.exe", "www.google.de")

    ....

    EndFunc

    .....

    Func Chrome Öffnen und weiteres


    Ich danke euch im vorraus.

    Gruß Bernd

    PS: Der Bereich ist ca. 50 Zeilen lang

  • Opt ("SendKeyDelay", 150)

    • Bernd Albrecht
    • 13. Juli 2020 um 19:31

    alpines danke für die schnelle antwort. Ich hab mich etwas dumm angestellt.

    Für diejenigen mit einem gleichen Anliegen:
    Opt("SendKeyDelay", 150) ist dann nicht mehr gültig wenn ein anderes Opt("SendKeyDelay", xxx) verwendet wird.

    Gruß Bernd

Spenden

Jeder Euro hilft uns, Euch zu helfen.

Download

AutoIt Tutorial
AutoIt Buch
Onlinehilfe
AutoIt Entwickler
  1. Datenschutzerklärung
  2. Impressum
  3. Shoutbox-Archiv
Community-Software: WoltLab Suite™