Jump to content
Macro Express Forums

Adding specific variables to fields from .cvs files


tocmo0nlord
 Share

Recommended Posts

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!

Link to comment
Share on other sites

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>

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...