excel scripting

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.

Try another simple one: Again start up Notepad, but enter this text:
strMyName = InputBox ("Enter your name")
MsgBox strMyName & " is my master!"
Again, save it (any name with a .vbs extension) and double-click it. Easy.

Now you may be asking where I can find more commands easy all you have to do is record a macro with a set of action that you want to use. and then use the script editor in excel to view the code ie try this link
http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=302