+ Reply to Thread
Results 1 to 3 of 3

Working 2007 excel add-in wont work with excell 2010 version. Please help.

  1. #1
    Registered User
    Join Date
    03-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Talking Working 2007 excel add-in wont work with excell 2010 version. Please help.

    This excel add-in works fine on Excel 2007 version.
    http://1drv.ms/MX5Pw3

    I get the following errors if I try it on Excel 2010.
    - "Cant find project or library."

    Capture.PNG

    In VBA project references I have this:
    - X - MISSING: Microsoft XLM Version 2.0

    2Capture.jpg

    Can someone please explain me how to update the file (or how to configure Excel 2010) and make it 2010 compatible?

    Use the following numbers to test. Paste in column A then press “tracking”.

    1ZW5230V6664448448
    1Z2XY1350496203469
    1Z6177WY0477123375
    1Z3ER6120499142012

    Thanks!
    Last edited by kraft_mk; 02-25-2014 at 04:17 AM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: Working 2007 excel add-in wont work with excell 2010 version. Please help.

    You can try deselecting the Missing reference and Excel should find the updated alternative automatically... If not you need to manually find the new XML reference within the list.
    Elegant Simplicity............. Not Always

  3. #3
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Working 2007 excel add-in wont work with excell 2010 version. Please help.

    Change XML reference to later version - for example Microsoft XML 6.0 and change Tracking_Liste routine beginning:
    Please Login or Register  to view this content.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  4. #4
    Registered User
    Join Date
    03-19-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Working 2007 excel add-in wont work with excell 2010 version. Please help.

    Hello Izandol.

    I already did changed XML reference to the latest versions few times, as suggested on lots of sites (Microsoft XML 3.0 and 6.0) without any success.
    I also asked the same question on few sites, and everywhere I got the same suggestion. "Just change the XML reference and everything should work."

    But,
    You were the only one that wrote the corrections in the programing code and fixed my problem successfully.

    After my few unsuccessful attempts, stars aligned, and everything started to work again.

    I cannot thank you enough for your help and I really appreciate the time you shared for helping me and others.

    Thank you again,

    K
    Last edited by kraft_mk; 02-26-2014 at 03:11 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2010 VBA & Macros - Wont work in Open Office
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-31-2013, 04:49 AM
  2. coding previously working in Excel 2003 version not working in Excel 2010
    By petercalbra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2012, 10:51 AM
  3. Replies: 4
    Last Post: 05-20-2012, 08:44 AM
  4. CommonDialog Excel 2007 wont work
    By dryan83 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-30-2010, 05:07 PM
  5. Excel 2007 to 2010 version problem
    By Gundersen in forum Excel General
    Replies: 0
    Last Post: 03-31-2010, 09:01 AM

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