CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008
    Posts
    2

    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 !

  2. #2
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Different index for workbooks

    Post your code!
    Code:
    '    and use code tags
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

  3. #3
    Join Date
    Nov 2008
    Posts
    2

    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
  •  





Click Here to Expand Forum to Full Width

Featured