By
Evolutionnext
I am still a noob and not a programmer, would greatly appreciate your help.
Task:
Open Excel file with file path and name: C:\Users\GENOBEAUTYPC1\Desktop\ACTIVE BEAUTY LABELS\BeautyMe Label 200ml ACTIVE VERSION.xlsx
This file path and name is saved in the variable: $sAnswer
Go to Excel Tab called "formular"
Go to Cell A1
Insert the text saved in the variable: $sAnswer2
ATTENTION!!! This has 2 problems.
Problem number 1: This text contains special characters that need to be interpreted as raw text. (content is: Gemischt für#30 ml#Mindestens haltbar bis#Maria Wallerstorfer#Anwendung: Täglich 1x morgens auf das gereinigte Gesicht auftragen. Augenkontakt vermeiden.#Über 0 C° und unter 25 C° lagern.#Lot:N8A1028/D30/V2.1#Genome Plus GmbH#Georg-Wrede-St. 13, D-83395 Freilassing#GEN SERUM#DAY)
Problem number 2: This textis longer than 255 characters.
Can anyone help me?
I try to do it really primitively by opening the excel, waiting until it is open, clicking where the tab is, clicking where the cell is and inserting the content of the variable, but I am stuck at the point where I am limited by 255 characters.
; Opening the right excel FileChangeDir
tooltip("File exists and is called:"&$sAnswer ,300,300)
ShellExecute($sAnswer ,"" ,"" ,"" , @SW_MAXIMIZE)
sleep(7000)
tooltip("Now lets insert the right content into the excel",300,300)
MouseClick("left",226,1004)
MouseClick("left",52,179)
sleep(500)
Send("A1")
sleep(500)
send("{enter}")
tooltip("inserting label content",300,300)
sleep(500)
Send($sAnswer2, 1)
tooltip("inserting INCIS",300,300)
sleep(5000)
Send($sAnswer3, 1)
sleep(5000)
6
