tocmo0nlord Posted April 5, 2009 Report Share Posted April 5, 2009 Ive got ASCII Delimited Text File Process and it pastes all the fields correctly. First Second Third Forth from a csv file. I would like to take those fields and have the macro enter them into boxes on a different program. the Get control for those boxes have already been set, how would i acomplish this? To rectify, I would like macro express to enter the output of the csv file into boxes into another program. Thanks guys! Quote Link to comment Share on other sites More sharing options...
tocmo0nlord Posted April 5, 2009 Author Report Share Posted April 5, 2009 Ive got ASCII Delimited Text File Process and it pastes all the fields correctly. First Second Third Forth from a csv file. I would like to take those fields and have the macro enter them into boxes on a different program. the Get control for those boxes have already been set, how would i acomplish this? To rectify, I would like macro express to enter the output of the csv file into boxes into another program. Thanks guys! I broke it down into 2 diff processes. 1) process the .cvs file into a wordpad to the way it needs to be entered into the boxes. 2) created a macro with <Page Up> / <Home> / <Shift> / <End> / and so on controling the text passing it over from the wordpad to the program with the boxes, then removing the processed text and repeating. I am jumping all over the place, wont have to process over 1,000 files manualy lol. I would still like to cut step one and enter the files directly into the boxes with the macro. Is this possible? Thanks you. Heres number one: <SPKEY:0003><ADFBEG:F10:001:000001:000000:C:\Documents and Settings\mehhhh\Desktop\Macro Shortcuts\Termination.csv><TEXTTYPE:%T3%, %T2% %T2% %T3% %T2% %T3% %T1% ><ADFEND> Heres number 2 <REM2:Contact Name><GETCONTROL2:01:JAVAW.EXE:SWT_Window0Program Name016:20SWT_Window01SWT_Window010SWT_Window01SWT_Window01SWT_Window0 2SWT_Window05SWT_Window04SWT_Window01SWT_Window06SWT_Window09SWT_Win d ow01SWT_Window01SWT_Window01SWT_Window01SWT_Window02Edit><REM2:Full name><GETCONTROL2:02:JAVAW.EXE:SWT_Window0Program Name016:20SWT_Window01SWT_Window010SWT_Window01SWT_Window01SWT_Window0 2SWT_Window05SWT_Window04SWT_Window01SWT_Window06SWT_Window09SWT_Win d ow01SWT_Window01SWT_Window01SWT_Window04SWT_Window02Edit><REM2:First Name><GETCONTROL2:03:JAVAW.EXE:SWT_Window0Program Name016:20SWT_Window01SWT_Window010SWT_Window01SWT_Window01SWT_Window0 2SWT_Window05SWT_Window04SWT_Window01SWT_Window06SWT_Window09SWT_Win d ow01SWT_Window01SWT_Window01SWT_Window07SWT_Window02Edit><REM2:Last Name><GETCONTROL2:04:JAVAW.EXE:SWT_Window0Program Name016:20SWT_Window01SWT_Window010SWT_Window01SWT_Window01SWT_Window0 2SWT_Window05SWT_Window04SWT_Window01SWT_Window06SWT_Window09SWT_Win d ow01SWT_Window01SWT_Window01SWT_Window010SWT_Window02Edit><REM2:Employee ID><GETCONTROL2:05:JAVAW.EXE:SWT_Window0Program Name016:20SWT_Window01SWT_Window010SWT_Window01SWT_Window01SWT_Window0 2SWT_Window05SWT_Window04SWT_Window01SWT_Window06SWT_Window09SWT_Win d ow01SWT_Window01SWT_Window01SWT_Window013SWT_Window02Edit><REP3:01:000001:000001:01000:0:01:><REM2:Start the clicking LOL><REM2:Contact Name><ACTIVATE2:Document - WordPad><TEXTTYPE:<PAGE UP><SHIFTD><END><SHIFTU><CTRLD>c<CTRLU>><ACTIVATE2:Program Name><CCLICK:T:01:0:T:><TEXTTYPE:<CTRLD>a<CTRLU>><CLIPP><DIS:<DELAY:1><REM2:Full name><ACTIVATE2:Document - WordPad><TEXTTYPE:<HOME><ARROW DOWN><SHIFTD><END><SHIFTU><CTRLD>c<CTRLU>><ACTIVATE2:Program Name><CCLICK:T:02:0:T:><TEXTTYPE:<CTRLD>a<CTRLU>><CLIPP><DIS:<DELAY:1><REM2:First Name><ACTIVATE2:Document - WordPad><TEXTTYPE:<HOME><ARROW DOWN><SHIFTD><END><SHIFTU><CTRLD>c<CTRLU>><ACTIVATE2:Program Name><CCLICK:T:03:0:T:><TEXTTYPE:<CTRLD>a<CTRLU>><CLIPP><DIS:<DELAY:1><REM2:Last Name><ACTIVATE2:Document - WordPad><TEXTTYPE:<HOME><ARROW DOWN><SHIFTD><END><SHIFTU><CTRLD>c<CTRLU>><ACTIVATE2:Program Name><CCLICK:T:04:0:T:><TEXTTYPE:<CTRLD>a<CTRLU>><CLIPP><DIS:<DELAY:1><REM2:Employee ID><ACTIVATE2:Document - WordPad><TEXTTYPE:<HOME><ARROW DOWN><SHIFTD><END><SHIFTU><CTRLD>c<CTRLU>><ACTIVATE2:Program Name><CCLICK:T:05:0:T:><TEXTTYPE:<CTRLD>a<CTRLU>><CLIPP><DIS:<DELAY:1><REM2:Add Contact.><TEXTTYPE:<F2>><DELAY:2><TEXTTYPE:<F2>><REM2:Clear to new Begining / Repeat. ><ACTIVATE2:Document - WordPad><TEXTTYPE:<HOME><ARROW DOWN><ARROW DOWN><SHIFTD><ARROW UP><ARROW UP><ARROW UP><ARROW UP><ARROW UP><ARROW UP><SHIFTU><DELETE>><DELAY:3><ENDREP> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.