Results 1 to 10 of 14

Thread: Moving past VBA

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Moving past VBA

    I've been using VBA for a couple of years now but want to get more serious and move to Visual Studio for developing my Excel solutions and perhaps onward from there.

    Advice, should I stick with VB or should I bite the bullet and learn C before investing to heavily in VB?

    Jesse

  2. #2
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Ístersund, Sweden
    Posts
    12
    Articles
    0
    Jesse,
    VB and C# are quite similar in .NET, i.e VB is a full member of the .NET platform. I cannot see any reason that force You to learn C#. The only major difference between them is that C# can be more used for advanced plumbing. If You use an earlier version of VS then 2010 then VB is the preferable language to use as with C# You must always declare all parameters in Excel's objects/method/properties.

    If You have been working with VBA then it will be easier to port the code to VB then to C#.
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    hello Dennis, how are you?

    I believe Excel DNA works with the free versions of MS Studio
    Hope that helps

    Roy

  4. #4
    Thanks Roy, I hadn't seen Excel DNA before, I'm going to check it out for sure.

    Jesse

  5. #5
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    Have you checked Dennis' site links?

    Maybe someone can provide some links to other demos & tutorials
    Hope that helps

    Roy

  6. #6
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Ístersund, Sweden
    Posts
    12
    Articles
    0
    Hey Guys,

    My main site, ExcelKB, is at present empty, some of its contest can be found at MSDN (VBA) and all the Lotus / Excel material can be found at Ron de Bruin site. But all my VB.NET material is on a local drive.

    Instead of pointing to some code pages I think its good to start with the following article at WikiPedia: Comparison of C Sharp and Visual Basic.NET
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  7. #7
    Thanks Dennis. Do you have a quick example of what sort of things would require C#?

  8. #8

    Moving past VBA

    Quote Originally Posted by Jesse View Post
    I've been using VBA for a couple of years now but want to get more serious and move to Visual Studio for developing my Excel solutions and perhaps onward from there.

    Advice, should I stick with VB or should I bite the bullet and learn C before investing to heavily in VB?

    Jesse
    No need to study C for VBA. But a better optionis to study C#. Because nowadays most old VB projects are mving to C# and C# is getting very popularity recently. You can do anything C# like in VBA .

    ling.

  9. #9
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Ístersund, Sweden
    Posts
    12
    Articles
    0
    I disagree about C#:

    # Microsoft treat both C# and VB.NET equally so there is no difference

    # Books about each language is also nearly a 50/50 situation

    # VB.NET is not the successor of VB, it's a 100 % NET language

    If You still insist I would like to see a reference to any officially source that shows explicit that C# is more popular.
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

Posting Permissions

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