InfoConnect for Airlines VBA Guide
Xfr400StartRecord Property
Use this property to skip a given number of records at the start of a file before sending the file to the AS/400.
Object.Xfr400StartRecord As Long

Property Value

The range of values is 1 - 32,768. The default is 1, which means the entire file is sent to the host. Specifying 2 means that the first record in the file will be skipped (not sent to the host), and so on.

For example, if you have an Excel spreadsheet that contains header information in the first line, you can skip this line before transferring this file. Changing this property from the default, 1, is especially useful if this header information causes a problem for an AS/400 program that analyzes the uploaded data.


If you transfer a file to the AS/400 and then later attempt to transfer that same file to the AS/400 while specifying a start record greater than the number of records contained in it, the transfer will fail and the original file is preserved on the AS/400.

This property affects AS/400 data transfer and is only relevant for 5250 sessions.

See Also