Hi Michelle I think the only thing your lacking is the use of the "view" command and a small "IF Else" statement that would look something like this.
' If the val of the 5 characters in row 4, starting in column 78 are greater then 0 If Val(View(Row:=4, col:=78, length:=5)) > 0 Then Tab_ ' Tab past the value Else Enter 0 ' enter a 0 End If If this doesn't help, give me a call at (831) 759-1878 Paul -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barker, Michelle Sent: Tuesday, July 01, 2003 5:44 AM To: '[EMAIL PROTECTED]' Subject: RE: Scripting Help for Newbie (with attachment) ... here's the attachment - I was trying to get out of the office a little too quickly last night. Thanks Michelle -----Original Message----- From: Barker, Michelle [mailto:[EMAIL PROTECTED] Sent: Monday, June 30, 2003 5:55 PM To: '[EMAIL PROTECTED]' Subject: Scripting Help for Newbie Hi, I need help on 3 steps in my script: 1. I have a field that needs to be evaluated when the cursor stops on it. If there is a value the script should tab past it, if there isn't a value the script needs to add a zero. 2. When the script comes to a list field I need to send the "Page Down" key to it so the cursor will go to the next available space. 3. All my scripts in the past have been very simple and have read from a data file consisting of a list of numbers, mnemonics, etc. I now need to read from a list that contains an ID and a value (i.e. employee ID and allowance $ value). My data file is tab delimited and I can get the column number for each value, but I'm not sure how to write the loop to put the correct data where I need it. I've attach part of the steps I'm doing (without the loop). Thanks Michelle 617-665-3432 Clinical Application Analyst CHA Information Technology [EMAIL PROTECTED]
