Results 1 to 4 of 4

Thread: How can I make reference to older EXCEL versions

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2006
    Location
    NC
    Posts
    4

    How can I make reference to older EXCEL versions

    I have Excel 2003 (v 11) on my machine but the machine that the VB exe will operate on has on older version of Excel. What do I do to make the reference links work in this case?

    I tried to put a copy of his excel.exe file on my PC and link a reference to that but it did not work.

    There has to be a way!

    Someone please help me. An email to [email address removed] with any advise is also greatly appreciated!!!!
    Last edited by Hack; May 17th, 2006 at 07:46 AM.

  2. #2
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: How can I make reference to older EXCEL versions

    I have edited your post and removed your email address.

    You should never post your email address in an open post on an open forum. Mail spam bots can pick that up and before you know it, your mailbox is full of junk mail. If you wish to share your email address with other forum members, please do so via our PM system.

    Thanks.

  3. #3
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: How can I make reference to older EXCEL versions

    Just use Late Binding - see the Excel Tutorial link in my signature for an explanation of how to do it.

  4. #4
    Ex-Super Mod RobDog888's Avatar
    Join Date
    Apr 2001
    Location
    LA, Calif. Raiders #1 AKA:Gangsta Yoda™
    Posts
    60,709

    Re: How can I make reference to older EXCEL versions

    Any version of Excel or other Office apps are not redistributable. Use Late Binding like in Si's tutorial. Just make sure your only using functions and methods that are common and supported by the versions you want to support.
    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

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