hai i understand ur prob
add excel9.olb library to ur vb library set
then using help for their methods and classes
u can easily got ur result.........
because recently i also developed
a system with same requirement.........bye..