Hi,

how can i export the worksheet (Sheet1) to text file using the restriction/rules in "Txt Layout" sheet.. In column G, this is the corresponding column in Sheet1.. some data is constant in the text file.. pls refer to the attach file.. if the data in the worksheet exceed the field length, it will only get the number of digits/characters provided in that field (for example, if the field length is 35 characters, only 35 characters will be shown and others will be drop)..


Thanks..