Increment variable name

[mgrantom]

Please excuse my ignorance, but I have tried to find the answer in the knowledgebase and in the forum to no avail. I have an application that displays records containing 45 fields. I need to capture all 45 fields. I’m trying to use the Repeat with variable function. After the repeat statement, I want to use clipboard clear and copy to put the first field contents into variable T1. I then want to tab to the next field and have the next value clipboard copied into T2 etc until all 45 fields are captured. This is probably really basic, but I can’t figure out how to increment the variable name to the next number T2, T3 etc. Am I missing something really basic here? Any help would be appreciated. Thanks

[kevin]

What you want to do is use something like %T%N1%% to access a sequential series of variables (%T1%, %T2%, %T3%, etc.) inside a repeat loop. To do this you need to enable the Variable Evaluation Level. If using Macro Express v 3.7 or later click Options, Preferences, Miscellaneous, Advanced and set the 'Variables Evaluation Level' to 1 or 2.

 

For information about this feature see the Macro Express News - July 13, 2005 newsletter and the User Submitted Macro - Variable Evaluation Level shared macro page.

 

Other discussions on this topic within this discussion forum can be found at these links:

• Repeat Variable Loop
  
• Able To Use Variable In Variable Names?
  
• Nested Variable?, How do I make a variable variable?
  
• Setting Variable %t%n1%%
  

[Shai]

What you want to do is use something like %T%N1%% to access a sequential series of variables (%T1%, %T2%, %T3%, etc.) inside a repeat loop. To do this you need to enable the Variable Evaluation Level. If using Macro Express v 3.7 or later click Options, Preferences, Miscellaneous, Advanced and set the 'Variables Evaluation Level' to 1 or 2.

 

For information about this feature see the Macro Express News - July 13, 2005 newsletter and the User Submitted Macro - Variable Evaluation Level shared macro page.

 

Other discussions on this topic within this discussion forum can be found at these links:

• Repeat Variable Loop
  
• Able To Use Variable In Variable Names?
  
• Nested Variable?, How do I make a variable variable?
  
• Setting Variable %t%n1%%
  

 

 

Ahhhhh, I had tried to do this but ME complained so I assumed it could not be done. Thanks. Now if I can just remember the logic I was going to use it in