Results 1 to 4 of 4

Thread: multiple Excel Versions...

  1. #1

    Thread Starter
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126

    multiple Excel Versions...

    I have a system with both Excel 97 and Excel XP installed, running on Windows XP.

    I click on a file with an .xls extension and it always opens in XP.

    I go to the OPEN WITH screen, and Excel 97 is not even listed as an option. If I browse for 97 and manually selected it, and check the "always use this program to open this file", it will work once, then revert to using Excel XP.

    I would like to be able to double click on any Excel file and have it open in 97, not in XP, any suggestions.
    -----
    #VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP

    I miss my VIC 20.
    Never should have upgraded to my commodore 64. ...

  2. #2
    PowerPoster lintz's Avatar
    Join Date
    Mar 2003
    Location
    The 19th Hole
    Posts
    2,697
    Uninstall your Excel XP version so your files can only open in Excel 97.

    BTW....why would you want Excel 97 instead of Excel XP?

  3. #3
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709
    That wouldn't work since he needs both versions to develop with.


    I remember comming accross some registry setting that
    contained the information for the recent open with context menu.
    Maybe you could add a custom menu item when you right click it
    will give you the option to open with Excel 97?

    I have done dual installs of Access 97 and 2000 before which did
    what you wanted, it relied upon a certain font not being
    overwritten during the Access 2000 install. Try searching M$ to
    see if there is anything on Excel.

    HTH
    VB/Office Guru™ (AKA: Gangsta Yoda®)
    I dont answer coding questions via PM. Please post a thread in the appropriate forum.

    Microsoft MVP 2006-2011
    Office Development FAQ (C#, VB.NET, VB 6, VBA)
    Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET
    If a post has helped you then Please Rate it!
    Reps & Rating PostsVS.NET on Vista Multiple .NET Framework Versions Office Primary Interop AssembliesVB/Office Guru™ Word SpellChecker™.NETVB/Office Guru™ Word SpellChecker™ VB6VB.NET Attributes Ex.Outlook Global Address ListAPI Viewer utility.NET API Viewer Utility
    System: Intel i7 6850K, Geforce GTX1060, Samsung M.2 1 TB & SATA 500 GB, 32 GBs DDR4 3300 Quad Channel RAM, 2 Viewsonic 24" LCDs, Windows 10, Office 2016, VS 2019, VB6 SP6

  4. #4

    Thread Starter
    Lively Member TheFIDDLER's Avatar
    Join Date
    May 2002
    Location
    here and there and far away
    Posts
    126
    Thanks.

    I know of the registry settings for the recent files in the registry. I will play around with that tonight to see if it accomplishes anything.

    I will search if there is a registry setting for the .xls extension, which I think there is.

    Most promising, I think, is using a batch file or vscript, where I open Excel.exe by the full path name, specifying a file open parameter.

    I do need to have both versions installed, and most of my work is in Excel 97. Makes sense to do this as it allows my application to be used by the most number of users. And then my files work in 97 and up.
    -----
    #VBA, VB 6 Professional Edition, Office XP Developper. Excel 97, Excel 2000, Excel XP

    I miss my VIC 20.
    Never should have upgraded to my commodore 64. ...

Posting Permissions

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



Click Here to Expand Forum to Full Width