Results 1 to 7 of 7

Thread: 2002 vs. XP

  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2002 vs. XP

    I am highly confused as to what the difference is (if there is one) between Office 2002 and Office XP. I have seen the terms used in different places and do not know if they are the same or not. I use Excel VBA a lot with xl97 and xl2000 and want to also give whatever is the next version but is it called Excel 2002 or Excel XP? I looked on Amazon's site and see software called by both names.

    Deb <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2002 vs. XP

    Hi Deb,

    Office XP is the name of the suite containing the Applications 2002.
    See <A target="_blank" HREF=http://www.microsoft.com/office/howtobuy/choosing.htm>here</A>.
    We can count on MS to make things complicated as it can be simple. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>

  4. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2002 vs. XP

    I suspect they discovered that Office 2002 is quite a mouthful and wanted to encourage a tie-in with Windows XP anyhow. However, there is a problem between the VBE for Office 2000 and the one installed by Office XP. A hotpatch is in the works, but they haven't announced it yet as far as I know. The problem will unexpectedly corrupt the code in a 2000 project, and even with the patch, anything corrupted will still be corrupted because it won't fix that, ony prevent it from happening again.
    Charlotte

  5. #4
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2002 vs. XP

    Great, thanks for the warning!! I will edit my code to prevent a user who has XP from running my Excel project (written/tested in xl97 and xl2000) else while they're using the thing, it might blow up and do weird things and they'll come crying to me. <img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> I'll tell them about the pending patch though.

    Thanks for the heads up, I'm off now to search the MS KB for this article and any other potential bombs. I will also load XP on a spare PC I have and start testing it with my Excel workbooks.

    Deb <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

  6. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2002 vs. XP

    Here's the link on the problem: <A target="_blank" HREF=http://support.microsoft.com/default.aspx?scid=kb;EN-US;q304548>ACC2000: Error Message: Error Accessing File. Network Connection May Have Been Lost. (Q304548)</A>
    Charlotte

  7. #6
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2002 vs. XP

    Ah, good, it's for Access only so I won't see that error as all my work is in Excel. Whew. I did however, look thru what I could find in the KB for 'vba' and 'XP' and found about 20 items.

    Thnx, Deb <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  8. #7
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: 2002 vs. XP

    Don't be too sure it won't affect the other apps. Remember that the entire Office suite uses the same VBE library.
    Charlotte

Posting Permissions

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