+ Reply to Thread
Results 1 to 14 of 14

Message when opening in Excel version 2010

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Message when opening in Excel version 2010

    Hello everybody,

    Is it possible to show a message box when a workbook is opnened in version 2010?
    I would like to give users some instructions for an error that occurs when opening in 2010.

    Some features I used aren't recognized in 2010 and gives the error:
    "Compile Error: Can't find project or library"

    This can be solved by following these instructions:
    1. Open the database or application.
    2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
    3. On the Tools menu, click References.
    4. Clear the check box for the type library or object library marked as "Missing:"

    Even better still would be if these steps can be done utomatically

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Message when opening in Excel version 2010

    Surely it's better to fix the problem. I suspect you use a Calendar control, if so use an alternative such as suggested here
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    Hi Roy,

    Thanks for your comment.
    I don't like using add-ins though

    Besides, the Calendar Control isn't the only problem.
    This code gives the same error:

    Please Login or Register  to view this content.

  4. #4
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    Quote Originally Posted by Jonathan78 View Post
    Hello everybody,

    Is it possible to show a message box when a workbook is opnened in version 2010?
    I would like to give users some instructions for an error that occurs when opening in 2010.

    Some features I used aren't recognized in 2010 and gives the error:
    "Compile Error: Can't find project or library"

    This can be solved by following these instructions:
    1. Open the database or application.
    2. Open a module in Design view or press ALT+F11 to switch to the Visual Basic Editor.
    3. On the Tools menu, click References.
    4. Clear the check box for the type library or object library marked as "Missing:"

    Even better still would be if these steps can be done utomatically
    I still haven't found a solution for this.
    Any ideas?

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Message when opening in Excel version 2010

    Check what references are missing. I think you will find it is caused by the missing Calendar Control

  6. #6
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    It is, but how can I solve it.
    It needs to work in both 2003 and 2010

  7. #7
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Message when opening in Excel version 2010

    The link that I posted previously has alternatives to adapt. I never use AxtiveX calendar controls because of the problems associated with them

  8. #8
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    It gives a "run-time error 9" [Subscript out of range] even when my mouse rolls over the "JR_Datepicker_Show"

  9. #9
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    Solved!
    I had it wrongly installed

  10. #10
    Valued Forum Contributor
    Join Date
    07-21-2008
    Location
    London, UK
    Posts
    326

    Re: Message when opening in Excel version 2010

    R_Datepicker_Show add in works correctly if installed, glad you got it working OK and You will find less problems

    Credit to RoyUK

  11. #11
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    Last question about this.
    Is it possible to run a add-in via a commancdbutton?

  12. #12
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Message when opening in Excel version 2010

    Not sure what you mean. I can give you code to show the calendar but it will have to be when I get home, I haven't got the addin code with me.

    The calendar form example is open & you can see the code to use in your workbooks.

  13. #13
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Re: Message when opening in Excel version 2010

    Hi Roy,

    I mean: is there a way to call a add-in from a comandbutton, instead of from the menubar etc.

  14. #14
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Message when opening in Excel version 2010

    You can call an addin's macro if you know the name

    Please Login or Register  to view this content.
    MyMacro would need to be the correct name of the macro & file.xla the addin's name

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1