invoke commands used for excell

[DRL]

I am using a propritary software that can use script to invoke excel
operations. Is there a list of the commands that excel will accept. Basically
this software creates a report and until now the user would copy as a meta
and paste into excel. I need to
1) create the work book
2) create the worksheet(and name it with a variable that I already have)
3) place the data in the worksheet
and repeat for 10 worksheets.

Thanks

 

[Mark Ivey]

I would say to start with researching VB Scripting to automate MS Excel and
then go from there. You can do quite a bit more than these sites below are
showing. It just takes some imagination.

http://support.microsoft.com/kb/198703

http://www.activexperts.com/activmonitor/windowsmanagement/scripts/msoffice/excel/