i came to this group only after few unsuccessful attempts. anyway the
problem with the macro that i want is that excel's unable to get the
info from other software. For eg. if i record a macro after punching a
client id and i want excel to get all the information of that client
from other software; it simply won't do. As soon as i run it, it
repeats with the client id with which it was recorded.
Hope i've been able to clarify it.
Now would you please tell me if it's possible?

Thanks.