Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Object librarys (excel 2003)

    At work there is computers that have microsoft object library 10.0 and some with 11.0

    I am woundering if this will cause problems.

    for example, I have a work book that I made that has lots of nice drop downs (combo boxes and check boxes)
    they work great for what I need them for. When I place the workbook on the network, and a user with object library 10.0 uses the workbook and saves it
    things start to dismantle. What I have noticed is that If I open the work book from my station with object library 11.0 I get a message Data has be lost and once i click through all the msg boxes, I come to the workbook that ws save by the user which nolonger has my nice combo boxes nor check boxes.

    What can I do, all suggestion would be good. Personally I think that the place i work will need to update all the old excel 00 to excel 03.
    Anyone have other suggestions??

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    One way around this problem is to use the controls from the Forms toolbar.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    Can I ask what the differece is between control toolbox forms and users forms in general, and in this situation of sharing over two different object libararies?

    What is the references in VBA and What is an OBject library?

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    There are two sets of controls you can place on a worksheet:

    1 Control toolbox controls (from the Control toolbox toolbar)
    2 Forms controls (From the Forms toolbar)

    I assumed you used #1 and would advise #2.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    The user form type of combo boxes returns a number instead of what I pick in a list

    is there a way to change this?

    What makes the userform so much more compatible then the control toolbox?
    I also notice that the size of the font in the control tool box is controlled only by the zoom, there is no way to make it bigger. ie realy mall if my worksheet zoom is set at 75%

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Object librarys (excel 2003)

    The forms objects will give the index value. What you can do to get the actual selection is to use a formula:
    =Index(DataRange,IndexValue)

    to get the selected value/name (DataRange is the range you filled the object with, and the IndexValue is the cell you have it linked).

    The userform is more compatible since it is not dependent on the object library (which seems to be your issue).

    The size of the FORMS items can not be changed. The workaround is to find the zoom size which optimizes the size of the text in the object and then use larger/smaller fonts in your worksheet to adjust for the size you want.

    Steve

  7. #7
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    yes the object library is my problem. There are computers here that have MS09.DLL object library , office10 library and office11 libraries

    Is there a way to download the latest library into 00 or do you need 03 to get object library 11?

    From a network stand point and that everything is working or communicating without any problems, should I be using office 00 as my platform if I am building Templates that many users will be using and the version office is either 00 or 03?

  8. #8
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    Is there a way to add color to the userform combo box?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Object librarys (excel 2003)

    Do you really need those libraries, i.e. do you get errors if you uncheck those libraries in Tools | References... (in the Visual Basic Editor)? The minimum set of libraries is Microsoft Visual Basic for Applications and Microsoft Excel n.0 Object Library. You cannot uncheck those, and they shouldn't pose problems when you switch between versions of Excel. If you really need the other libraries, you should develop your workbooks in the earliest (oldest) version of Excel you have to support. You cannot use the version 11.0 libraries in earlier versions.

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Object librarys (excel 2003)

    If you mean the combo box from the Forms toolbar, the answer is no. (The Forms toolbar has nothing to do with userforms)

  11. #11
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    so since I build my workbook in 03, can I remove all the combo boxes, open the workbook in 2000 and redo the combo boxes, or will I need to recreate the whole workbook in 2000 if i want to make it universal?

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Object librarys (excel 2003)

    It's probably sufficient to open the workbook in Excel 2000, clear the check boxes for the missing references to the 11.0 libraries, then tick the check boxes for the corresponding 9.0 libraries.
    You are very likely to have problems when going from a newer version to an older one, but not when going from an older version to a newer one, so once you have set the correct references in Excel 2000, the workbook should function correctly.

  13. #13
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    Will VBA code be affected?

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Object librarys (excel 2003)

    You can test whether VBA code will work by selecting Debug | Compile VBAProject in the Visual Basic Editor.

  15. #15
    2 Star Lounger
    Join Date
    May 2005
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Object librarys (excel 2003)

    Thanks for you time on this matter!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •