All,
How shall I do the datatype conversion from Long to Integer.
I did the following.

Dim vlong as long
dim value as integer

value=int(vlong). But I am getting the result that I expect.
Thanks.
Latha