For this code make sure that you have excel file Book1.xls under c:\ and write some dummy values in its first few cells.
Write the whole above code in a new test in QTP and run it.
This is an excellent source of excel object model. You will simply love this.
Excel Object Model
Just download the file (vbaxl11.exe) from here and when you install it, there will be a file vbaxl10.chm in the installed location.