Page 1 of 2 1 2 LastLast
Results 1 to 10 of 14

Thread: Moving past VBA

  1. #1

    Moving past VBA



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    153
    Articles
    0
    hello Dennis, how are you?

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

    Roy

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

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

    Jesse

  6. #6
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    153
    Articles
    0
    Have you checked Dennis' site links?

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

    Roy

  7. #7
    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

  8. #8
    Thanks Dennis, this article is excellent. Exactly what I needed.

    Jesse

  9. #9
    Jesse, be aware, at present Reporting Services only talks VB.

  10. #10
    Seeker XL-Dennis's Avatar
    Join Date
    Mar 2011
    Location
    Östersund, Sweden
    Posts
    12
    Articles
    0
    Bob,

    Can You have the kindness to elaborate it further? I get the impression that You say that we cannot use C# with SQL Server Reporting Services.
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

Page 1 of 2 1 2 LastLast

Posting Permissions

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