EMERGENCY - VB.net coding query !!!!!!

[dreams]

This is what i need to do.some info come in excel
format.it is personal data info.
A
card #:abc
Expenses:1.00
Expenses:2.00
expenses:3.00

B
Card# cde
Expenses:1.00
Expenses:2.00
expenses:3.00
Expenses:4.00
.....
Like this around 60 emplyees every month.expense details varies every month.
Now the program should copy the data for A alone and paste it in a separate excel sheet and send the excel sheet to A's email id.similarly for B's data.

Can this be achieved in VB.net.

Need suggestions or opinions very urgently.

TIA

[Charan]

Yes you can do that. google for "VBA".

[dreams]

thnx Charan..

Culd u pls explain hw to achieve this..

TiA

[Charan]

Check these links on how to work with Excel sheets

http://support.microsoft.com/kb/301982
http://support.microsoft.com/kb/302094

if you are using .NET 2.0 then you can use the System.Net.Mail namespace to send emails.

[dreams]

thnx m8..will giv it a shot..

any other suggestions????