You should post your question to a C (?) newsgroup. VBA is the usual
language here. Book1.xls is the default workbook name when Excel
opens. Maybe you aren't writing to the correct file because "C:\
\vivek.xls" has 2 slashes.

Merjet