gordy.tech

thanks, i got it to work

<COMMENT Value="Assumes a new, blank 'spreadsheet like' file is open, with text cursor at the start of the top line."/>
<COMMENT Value="For this demo it is the file 'C:\\1\\Gordy.xlsx'"/>
<COMMENT Value="Now get each line of source.txt into the ARRAY variable %Line%"/>
<COMMENT Value="And copy each line into the spreadsheet. So the first variable will be %Line[1]%, followed by %Line[2]%, etc."/>
<VARIABLE SET INTEGER Option="\x00" Destination="%x%" Value="1"/>
<TEXT FILE BEGIN PROCESS Filename="C:\\1\\source.txt" Start_Record="1" Process_All="TRUE" Records="5" Variable="%Line[]%"/>
<WINDOW ACTIVATE Title="Gordy" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/>
<DELAY Flags="\x01" Time="0.2"/>
<TEXT TYPE Action="0" Text="%Line[%x%]%<ENTER>"/>
<VARIABLE MODIFY INTEGER Option="\x07" Destination="%x%"/>
<TEXT TYPE Action="0" Text="<ARROW DOWN>"/>
<DELAY Flags="\x01" Time="0.1"/>
<TEXT FILE END PROCESS/>
 

here is what i get

thanks, i will try your macro next

unfortunately, I cannot cut n paste directly to the end application.  It is excel like, that is a grid, but the data must be entered one cell at a time and then navigate (arrow down) to the next cell.

When I am manually entering the data, the sequence is

1. enter or double click

2. type data ( 4 to 6 digit number OR 8 to 16 character string)

3.enter or click ok

4. arrow down

repeat

thanks

THANKS, 

<TEXT FILE BEGIN PROCESS Filename="C:\\1\\source.txt" Start_Record="1" Process_All="TRUE" Records="1" Variable="%test%"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t1%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t2%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t3%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t4%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t5%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<MOUSE LEFT DOUBLE CLICK/>
<TEXT TYPE Action="0" Text="%t6%<ENTER><ARROW DOWN>"/>
<DELAY Flags="\x12" Time="250"/>
<TEXT FILE END PROCESS/>
 

my csv file has one entry per line, 99 lines deep - i need to copy those to a spreadsheet like program - once the variables are loaded, the data will be entered one at a time then <ENTER>, then <ARROW DOWN>, then repeat - - - - i cant even get the first one to copy, all i get is %T1%