Go to Project References->Microsoft Excel x.0 Library
check it and now the Excel properties and methods are available to you in your VB Project. Now you can manipulate them as you like.