Jump to content
Macro Express Forums

Setting Variables From A Csv File


Gabriel
 Share

Recommended Posts

Each time we run our macro we set variables from an excel spreadsheet (Database) to run the process. The method we currently use is pretty crude, we open up an excel file and copy the variables to the clipboard and then set variables from clipboard.

 

Is there a way to export the excel file as a cvs file and process using ASCII Delimited File Process. We tried to implement the ASCII File Begin Process using, Start Processing Record Value “%N1%” and Process Partial Records Value “1” but couldn’t get it to work the way we intended.

 

We’re hoping we can process that first row of the spreadsheet and then the next time we run the macro process the second, then the third, and so on.

 

Example:

 

Name Age State

Sean 25 NY

Steve 40 NM

Ben 15 VT

 

 

Each time we run the macro we would like to pull the data from a csv file so:

 

First Run:

%T1% = Sean

%T2% = 25

%T3% = NY

 

Second Run:

%T1% = Steve

%T2% = 40

%T3% = NM

 

Third Run:

%T1% = Ben

%T2% = 15

%T3% = VT

 

 

If anyone has any suggestions or code that does something similar we’d appreciate the help

 

 

THX

:) Gabriel

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...