If you wanna find out more on the excel scripting goggle "VBA in excel"
http://www.google.ie/search?hl=en&client=firefox-a&rls=org.mozilla%3Aen-...
try this also
Start up Notepad. Enter this text:
MsgBox "Hello World!"
Save it as "HelloWorld.vbs" (Or any name with a .vbs extension. You need to save it with the quotes if you are using the default Windows behavior of hiding file extensions). Open up Explorer, find the file you just saved, and double-click it. Yes, it's that easy.
I was doing some work there on Friday when all of a sudden my PC started playing up again it had been fine for about 3-4 weeks. After much teasing I guessed that I had a corrupt file in one of my registry file in the system folder. O tried running the repair option on the Windows installation disk but had no luck as some idiot (mainly me probably) was looking for an admin password that had never been set, I cant seem to be able to repair my windows platform using the installation CD. So my only resort was to install a new image of windows on a recently purchase drive (luckily that I had it).