Importing a VB script into Excel.

[SRAutomater]

Hi,

I am using autoit to pull together some data and put it in an excel spreed sheet. The data is put into multiple worksheets within a single workbook. If you right click on one of the worksheets name, and then select "view code", you can add custom code for that worksheet. Right now I am just using send()'s to open up the VB editor and type in the entire script. This is slow, and I would like to put a script into each worksheet. It seems like there should be a way to create a string with my script and just set it equal to something... like $excelobject.Worksheets("name").Script = $scriptstring. I can't find anything like it in the MS Office object reference. Does anyone know if this is possible?

[SRAutomater]

Well, I don't know if this is possible or not, but I was able to accomplish the same thing by using AutoIt's COM support and implementing the VBA logic in AutoIt.