12 posts in this topic
I have excel file like this
and i want to cut cell/text from excel to other software.
I have to cut the cell of B column one by one and past into other software
If Winexists("No Data Found")
then restore cuted cell and goto next/down side cell
How to do it ?
Its possible to past previously copied text to somewhere with autoit script ?
If yes, How it ?
example : Before I copied ABCD and then copied the PQRS, how to past the previously copied ABCD ?
cause im too new in the Auto it world i will try it with the your help. hopefully.
I woud like to know how i can handle my Problem.
I have a Excel Data with 362 random numbers.
this numbers are a part of the filepath ...example
as u can see its the first number of the Excel data. After the first 4 numbers it shoud make a "_" than another 5 "_"
This is my first question. How can i handle this to make it Shell execute.
If i am in the path.
the code shoud search for specific PDF Files.
They are named like: 0050569E364B1ED79B900F73E62660EC.pdf
the first 15 letters are always the same
when he found this data he has to copy it on a Folder on the Desktop.
(There can also be 2 or 3 pdfs in one Folder with this letters)
Please give me some help :-)
as you know im on a very low autoit-level.
My question is: How can i read all PDFs from a Folder wich is open and copy them to a Folder on a Desktop.
The Folder wich contains the PDFs is variable Z:\Projektls\"*"*"*EVERYTIME ANOTHER ENDING"*"*"*"*"
There can be 1 PDF or even 15 PDFs.
i tried it with _FileListToArray and _FileCopy but i Need some help to understand this language
Wondering what I'm doing wrong.
as per my script, I activate an external program, copy data from it and I want to paste it into excel, after I clear the current sheet that is there.
It is some sort of an array as when I manually paste it into excel it expands across rows and down columns (number of which varies).
This repeats for Xno. of program instances, and consequently I would want it to cycle through x sheets.
So far I have the following, noting that I dont have the sheet clearing thing detailed yet, but I get the following error: "Error copying cells. @error = 4, @extended = -2147352567"
func Primary() For $i=0 to ubound($term)-1 WinActivate($term[$i]) sleep(500) MouseClick("left",$OptX,$opty) Clipput("") sleep(500) send("!a") sleep(100) Do sleep(100) until Clipget() ;activates sheet no. specified by $i+ 1, removes data from sheet and pastes new data, cycles to the next sheet ;function to clear sheet _Excel_RangeCopyPaste($oWorkbook1.Worksheets($i+1), Default , "A1") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeCopy Example 2", "Error copying cells." & @CRLF & "@error = " & @error & ", @extended = " & @extended) MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeCopy Example 2", "Range 'A1' from workbook _Excel3.xls successfully copied to 'G15'.") Next EndFunc
Any help would be great.