Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Backwards Compatability of XP (Excel XP)

    I have been building an Excel model using 2002/XP and keep getting caught with compatability issues when I load the file onto Excel 2000.

    So far, I have learned that the GETPIVOTDATA function doesn't travel. I then learned that "msoFileDialogFolderPicker" doesn't work in the earlier version. and now, I find that code that is running on my machine crashes on Excel 2000 when I use "Selection.TextToColumns" to parse data into separate columns.

    Rather than continue finding these by trial and error, I was wondering whether anyone can point me at a definitive listing of the differences. I've looked at the 'What's new etc.,' but that seems to more an advertisment for 2002 when what I really want is a list of those features in 2002 that are not compatible with 2000.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backwards Compatability of XP (Excel XP)

    In XL2000, If you go to Help in the VBE and do a search for New, you get these first three items:

    New Objects
    New Events
    New properties (by object)

    And there is an alphabetic list called New properties and Objects.
    All those listed there are not in earlier versions.

    Best thing to do is find a copy of the oldest version you need supported and build the application there. Then debug on later versions.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backwards Compatability of XP (Excel XP)

    If you do your development on the oldest version that it needs to run on, you will have little or no problems moving it to later versions.
    Legare Coleman

  4. #4
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backwards Compatability of XP (Excel XP)

    Thanks for the pointer. when I looked for the new features, I was in Excel rather than VBA.

    Unfortunately, I can't see 'TextToColumns' listed and this appears to be the method that is causing the problem unless perhaps the method existed in the earlier version but the format or structure changed. I used the macro recorder to capture the code I used here.

    Selection.CurrentRegion.Select ' parse data into columns
    Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote, comma:=True, _
    FieldInfo:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), _
    Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), _
    Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), _
    Array(13, 1), Array(14, 1)), TrailingMinusNumbers:=True

    On the same topic, can I install Excel 97 (the original version that I purchased many moons ago) onto the same machine? I used the serial number from this when I upgraded to XP so I'm not sure whether I can have both installed.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Backwards Compatability of XP (Excel XP)

    TexttoColumns is acceptable in XL97. I do NOT think the parameter "trailingminusnumbers" is acceptable. If you get rid of the last portion
    ", TrailingMinusNumbers:=True"
    I think it will be OK in XL97.

    Also the ARRAY parameter is optional and since you have all the columns as general (the default) you could get rid of that parameter also.

    Steve

  6. #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: Backwards Compatability of XP (Excel XP)

    Yes you can install multiple version of Excel. I have xl97 and xl2000 on the same PC and am about to install xl2002 as well. I just install them in their own directory. Also you might have to do a custom install and deselect the option that asks if you want to overwrite previous installs (I think that's the default).

    Also, I too have been burned many times by undocumented incompatibiitites between versions. In general as someone else said, you should develop in the oldest version you require and you usually won't have problems in the newer versions. (You should warn you users in advance if they have an incompatible version - do so in the workbook_open event.) You of course can't use new features (or write your own like I wrote my own Split since it's not in xl97) but it's easier than writing your code three times. I have found some programming syntax rules that work in newer versions but not xl97 so it's not just changes in functions to look out for. This is one of the things I hate about VBA development. It's greatly extended the time it takes to create any sizeable project, increase the stress level and further develops my profanity skills. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    I also never use any references or add-ins or anything other than very plain vanilla Excel VBA features. I cant' be bothered to deal with installing references on my user's PCs.

    Deb

  7. #7
    2 Star Lounger
    Join Date
    Nov 2001
    Location
    Toowoomba, Queensland, Australia
    Posts
    112
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Backwards Compatability of XP (Excel XP)

    Thanks to everybody for your help.

    When it comes to programming I see myself as an enthusiastic amateur. I work as a consultant in the supply chain area and specialise in developing quite complex models of supply chain networks using highly specialised proprietary modelling tools. Most of the models I have built are mixed integer linear programs that consume (and later regurgitate) vast amounts of data. I try to do as much of the data manipulation in Excel as it has been my experience that most clients have few, if any, in house skills in tools that might be more effective such as Access. (not that I'm any great shakes)

    On my current engagement, I have spent most of my time at the client's offices using their resources and it has only been now when I have been working from my own office trying to deliver some customised reports that I have realised the challenges raised by using different versions of Excel.

    Once again,
    Thanks for all your help....but I'm sure that I will be back but hopefully with a different set of problems!!

  8. #8
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Backwards Compatability of XP (Excel XP)

    Joe,

    To add to Deb's post...
    When installing / using multiple versions of MS suites or applications:

    1. Install the oldest version first
    2. Install in separate directories or partitions
    3 If you want to keep your start menu shortcuts for all versions then rename the older ones before installing the newer version.
    4. Only one version of Outlook can be installed on a single operating system.
    5. Do a custom install and specify when asked to not overwrite/replace the older versions.
    6, You should specify the version of Excel you want used to open files by registering it in 'Start - Run'.
    (Enter the full file name of Excel, note that /regserver is outside the quote marks.)

    "C:Program FilesMicrosoft OfficeOfficeExcel.exe" /regserver

    The above will register Excel 97 as the default on most systems - change the file path / file name as appropriate.

    7. Do Not run multiple versions at the same time. Close XL 97 before opening XL 2000 and vice versa.
    8. MS references follow in no particular order:

    290576
    218861
    214388
    292584
    210391

    Regards,

    Jim Cone
    San Francisco, CA

Posting Permissions

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