Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Sep 2001
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Wise counsel sought! (Excel 2002 )

    I'm new to the forum and need some advice..PLEASE!

    First a little background: I've some experience in VB6 (a lot in user interface stuff - not a lot in databases and automation projects). I have recently acquired Office XP Developer Edition. I want to write some code in either VB6 Or VBA that will automate the loading and formating of a tab delimted ASCII file into an Excel spreadsheet.

    I "think" I have a delima but am not sure so that's why I'm posting this message.

    If I write the code in Excel 2002 VBA and include it in a spreadsheet and my user has Excel '97 or 2000 will it work? My users may have different versions of Excel and what I want to avoid is having them all go out and purchase the latest version. Could I avoid this by writing the necessary code in VB6 (they will already have the VB6 runtime on their systems) and just put that on their system and have it run with all (most) versions of Excel?

    What this all boils down to is: how can I best write this so that it is compatible given the above scenario?

    Thanks for any and all advice!!

    dingo

  2. #2
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    Quakertown, PA, Pennsylvania, USA
    Posts
    517
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wise counsel sought! (Excel 2002 )

    Dingo: Most code is okay between the recent versions; particular I think the code you'll require. Someone will correct me if I'm wrong about that.

    You will want to write this code in a module in the personal.xls file (explained under help files), then put the personal.xls file into the user's XLSTART folder or another location that you have indicated on all users' Alternate Startup folder under Tools-Options-General tab in Excel (you could do a registry edit on login, right?).

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

    Re: Wise counsel sought! (Excel 2002 )

    You will need to stay away from using features that did not exist in the previous versions. If you do that, your code should work in any of those versions. I would obviously advise testing it in all three versions before giving it out. It is usually advisable, but not required, to write code in the oldest version is which it must run.

    or <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=71024&page=&v iew=&sb=&o=&vc=1#Post71024>This Thread might give you some ideas on how to do what you are talking about.
    Legare Coleman

  4. #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: Wise counsel sought! (Excel 2002 )

    I have been working with xl97 and xl2000 for the past 18 months on a large, complex project and I can tell you from experience there are many undocumented differences in the VBA. I only use the basic features, none of the added references so in just the plain vanilla VBA Excel internally has changed. It's always best to test your code in as many versions as you can before releasing it. For what you want to do, I think you're fine. The charts have caused me most of the problems (using VBA to dyamically generate them).

    I can say that 90% of the VBA model is the same across versions so maybe I've had lots of bad luck in hitting that 10% over and over again but I've been burned often enough to be very careful as to how I test.

    There are threads relating to this very topic (some by me). You know what ASSUME means, right? <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

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

  5. #5
    Star Lounger
    Join Date
    Sep 2001
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wise counsel sought! (Excel 2002 )

    Thanks to all that responded. I will tread carefully and seek the lowest common denominator...

  6. #6
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Wise counsel sought! (Excel 2002 )

    Actually, you should be careful assuming that one knows what ASSUME means. It also means 'Association of Statistics Specialists Using Microsoft Excel'. It is another forum for statisticians or people interested in statistics using microsoft Excel. FYI: try this website <A target="_blank" HREF=http://www.mailbase.ac.uk/lists/assume/> http://www.mailbase.ac.uk/lists/assume/ </A>
    But I agree with the point you made.

Posting Permissions

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