Results 1 to 3 of 3

Thread: VB6 or VB.NET for Excel?

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2005
    Posts
    1

    Question VB6 or VB.NET for Excel?

    Is either VB6 or VB.NET known to be more compatible with Excel? Any input is appreciated!

  2. #2
    Fanatic Member dannymking's Avatar
    Join Date
    Jul 2005
    Location
    Darlington, North East UK
    Posts
    677

    Re: VB6 or VB.NET for Excel?

    Hi and welcome..

    They both have their pro's and con's.. If you are familiar with VBA for Excel, then you will find the transition to VB6 easier than vb.Net.

    It really depends on what you are wanting to do with Excel, control or pull data from it.
    Danny

    Never Think Impossible

    If you find my answer helpful then please add to my reputation

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

    Re: VB6 or VB.NET for Excel?

    There really is not major differences in the code or anything to do with coding. Maybe distributing but it shouldnt be difficult.
    I'd also say it depends on your target. If you are wanting to write stuff for yourself then VBA or VB6 are fine and easy. If you are needing to deploy your apps to other users then a VB6 Add-In or .NET may be best.
    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