I have a problem with an application that uses excel workbooks and sheets, i need to use a different index than the usual integers or the name of the excel file itself, i tried to create a normal collection and add each new workbook to it with the index that i need by modifying the "Add" method (as should be done with any normal collection of objects), but i get the good old "Activex component cannot create object" error message.
I'd be more than delighted if anybody has a better idea.
Thanx a lot !
Thanks guys and sorry for bothering, i found the problem, and i'm sorry that it was such a dumb mistake ! and to be sure that my post might be of use to anyone, i'll remind everyone that the workbook must be set to a file before it can be passed to any collections !!, dumb mistake as i said.