Kynn, I have a suspicion that you didn't add a reference to Excel and I also suspect that you didn't create 'Test.xls'. May I suggest that you read the Excel Tutorial here..
http://www.vbforums.com/showthread.php?t=391665
It's really the best way to learn VB/Excel.