Autoit:Write in a new sheet of an opened but not saved Excel workbook

[hg2052]

I have an .au3 script that retrieves data from web pages and writes them in an EXcel workbook that it opens.

Hao can I make it write data from each web page in another sheet of the same workbook, without first saving the workbook and then reopening it?

[MuchTex]

I believe what you're asking for is _ExcelSheetAddNew(). After opening up a workbook you can simply use this function to open up a new sheet and begin writing data to it.

Edit- I don't have access to test it right now, but you might have to use _ExcelSheetActivate() before you begin writing data to it, although I highly doubt this is necessary.

Edited April 6, 2013 by MuchTex

[water]

You have to use _ExcelSheetActivate because all other functions just write to the active WorkSheet.

This will change with my ExcelEX UDF - but this is still in a very early Alpha state.

[hg2052]

MuchTex,

_ExcelSheetAddNew() needs 2 arguments. I cannot retrieve the second from a workbook on the desktop,where I did already fill Sheet1.

[water]

Does the workbook you talk about already have all needed worksheets or do you need to add new worksheets to the workbook?

[hg2052]

Water,

It has the sheets, as always when you launch Excel.exe : Book1 -> Sheet1,Sheet2,Sheet3...etc

[water]

MuchTex,

_ExcelSheetAddNew() needs 2 arguments. I cannot retrieve the second from a workbook on the desktop,where I did already fill Sheet1.

The second parameter is the name of the new sheet and is optional. If you don't know the name simply let Excel select a name.

[water]

Ok, lets stick with your on this subject where you hve already posted some code we can work on.

BTW: You know that the Mods don't like to see multiple threads on the same subject?

[hg2052]

Water,

2.Mods...I know.

But it's about 2 subjects in the same script.

1.In my script, when I tried to "let Excel choose",I got the error message saying it needed 2 parameters.

[water]

Can you please post the code you used. Parameter 2 of _ExcelSheetAddNew is definitely optional.