-
November 30th, 2008, 11:57 AM
#1
Different index for workbooks
Hello Everyone
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 !
-
November 30th, 2008, 12:46 PM
#2
Re: Different index for workbooks
Post your code!
Code:
' and use code tags
-
December 1st, 2008, 06:47 AM
#3
Re: Different index for workbooks
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.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|