how to specify the excel sheet you wanted while using Active X

[Garry]

could anyone tell me how to name or append to specific the excel sheet? i do not know where and how to set the path for it.

[Gorka Larrea]

if you want to name a workbook, you need a reference to it, and then use saveas method to give it a name and path. If you want a sheet in a specific point, you can use add method, and set which page you want after or before you are adding. You can use move to move a sheet from one position to another.
I recommend you to record a macro and watch the code for help.

Hope this helps

[Garry]

Hi Gorka, could you describe a bit more, on the setting of page before or after adding? Do you use a string or numeric to set the parameter, and if i want the datas to be set to say, workbook (project.xls), sheet 2, how would you set it? I tried to use index, rather than add method, and when i set the index to 0, the datas will be at sheet 1, and for other index numbers, there would be an error of code 1.