Jump to content
Macro Express Forums

gordy.tech

Members
  • Posts

    9
  • Joined

  • Last visited

gordy.tech's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. <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/>
  2. here is what i get %Line[1]% %Line[2]% %Line[3]% %Line[4]% %Line[5]% %Line[6]% %Line[7]% %Line[8]% %Line[9]% %Line[10]%
  3. 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
  4. <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/>
  5. 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%
×
×
  • Create New...