ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   invoke commands used for excell (https://www.excelbanter.com/excel-programming/378636-invoke-commands-used-excell.html)

DRL

invoke commands used for excell
 
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

invoke commands used for excell
 
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/activmon...soffice/excel/




"DRL" wrote in message
...
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





All times are GMT +1. The time now is 10:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com