Windows 7 and Windows XP compatibiltiy issues

Discussion in 'Windows 7 Software' started by jasonlee91, Aug 21, 2012.

  1. jasonlee91

    jasonlee91 New Member

    Joined:
    Aug 21, 2012
    Messages:
    4
    Likes Received:
    0
    Hello everyone.

    I dont know if I am posting in the right section. If not, I apologize.

    Since the office that I work at has been using more and more VBA, there has been lots of issues where code that is written in 7 is not able to run properly on XP. I noticed that if I open up the script in XP and resave it, then it recompiles and runs fine. But until that is done, many of our tools and scripts that we wrote on 7 machines wont run on XP.

    I realize that it is not too difficult to resave the file, but many of our files are cosntantly updated and many of the office members are not familiar with the developer portion of Excel.

    Is there a way that Excel/Windows7/Windows XP can be patched so that code written in Windows 7 is compatible with Windows XP?

    Any insight is very much appreciated!
     
  2. tbint

    tbint Senior Member

    Joined:
    Sep 25, 2010
    Messages:
    107
    Likes Received:
    0
  3. jasonlee91

    jasonlee91 New Member

    Joined:
    Aug 21, 2012
    Messages:
    4
    Likes Received:
    0
    Thank you for your response tbint.

    I actually found out that it has something to do with the ADODB reference that we are using to enable us to connect to our databases from within excel.

    The exact reference we use is "Microsft ActiveX Data Objects 2.5 Library" and apparently, MS has not yet released a viable patch for this.

    I was hoping some of the other users have found a work around for this.
     

Share This Page

Loading...