Results 1 to 4 of 4
  1. #1
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Windows 7, Excel 2010: Strange behavior of macros/functions

    I have macros and custom functions that were written 8-10 years ago that worked until we upgraded to Office 2010 and Windows 7. It was happening on my old PC, and it's still happening on my new machine. I get errors when I try to use what I thought were rock-stable macros. I have attached screen shots from two such problems. Could I please get some help?

    Thanks,

    Jim
    Attached Images Attached Images

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    1,050
    Thanks
    69
    Thanked 118 Times in 103 Posts
    With luck all you need to do is to toggle "on" the basic References for VBA to work with:

    In the VBA Editor (Alt F11) click on Tools then References. The first few items should all be checked eg:

    * Visual Basic for Applications
    * Microsoft Excel [version] Object Library
    * OLE automation
    * Microsoft Office [version] Object Library
    * Microsoft Forms [version] Object Library
    * Microsoft Scripting Runtime

    HTH

  3. #3
    Star Lounger SoonerJim's Avatar
    Join Date
    Aug 2011
    Location
    Temple, Texas USA
    Posts
    64
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Martin, a "Pip Pip" and "Cheerio" to you. After following your suggestion, all my home grown functions and macros are working perfectly. Thank you very much!

    Jim

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,754
    Thanks
    129
    Thanked 693 Times in 629 Posts
    Kudos to Martin!

Posting Permissions

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