capute zeros. 1

[sundar766]

i need help from you guys. thanks n advance.
the actual screen shows 0001 but copied in excel only 1
i need 0001 in excel sheet.
Dim SettlementNo as String
SettlementNO = Trim(Sess0.Screen.GetString(x, 40, 5))
.Cells(Rw, "A").Value = SettlementNO

 

[Skie]

Your cell is probably setup to remove the zeroes by default. You can fix this by changing the cells to text. Or you can add a single quote prior to when you set the value:

.Cells(Rw, "A").Value = "'" & SettlementNO

 

[sundar766]

Skie
thank you very much. it works fine.