+ Reply to Thread
Results 1 to 58 of 58

Difference between VBA & VB (Using Visual Studio)

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Difference between VBA & VB (Using Visual Studio)

    Hi Programmers,

    I currently know a bit of VBA and would like to start Programming in VB 4.5/6.0 (Using Visual Studio)

    I'd like to know If the syntax is pretty similar and can be learnt without much effort?

    I do not know any other Language except VBA as my Educational Qualification is not in IT. I'v learned programming from YouTube..

    My Only motive behind learning VB is the use of Visual Studio, so that I can make Add-ins for Excel.
    Cheers!
    Deep Dave

  2. #2
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Unless you can track down a really old version of Visual Studio, I don't think you can even do VB6 development - pretty sure there's no support for it in the newer versions anyway - I use 2013 and it's not in that.

    If you're talking about what's generally termed as Visual Basic now (.net) it's completely different, it's a different language with a broadly similar syntax and completely different concepts - VB.net is object orientated.

    You can develop addins in VB.Net or VB6 or plain old Excel, but VB6 may prove to be a challenge

  3. #3
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    I am not restricted to VB6. Anything which would help me learn how to Develop sophisticated Add-ins for Excel..

    Which one would you recommend?

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Well you can make them with VBA in excel.

    If you want something with a bit more grunt, I'd have a look at C#, it's a .net language so you can use it in Visual Studio and it's really pleasant to use. The reasons I'd suggest C# over VB.net are as follows:

    Firstly, it's completely new so there's not tendency to do things the way you're used to - this will make for a painful experience, remember that VB just looks like VBA - it's a false sense of security and a source of frustration
    Secondly, there's a much, much larger community - C# is a very popular language whereas VB isn't so much. This means that most examples and tutorials will be in C# so it's easier to learn and there are far more people to help you

    (Once you get used to it, you'll actually find that it's pretty easy to convert VB.Net code into C#, but it's probably easier that you learn the most popular)

    It's worth noting that both these languages are object orientated, so whichever one you choose, it'll be quite a different way of thinking than you're used to

  5. #5
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Great! But there are 2 things I would like to ask..

    1) Do I need to know C to learn C#?

    2) Are the basics totally different? I mean will I have to start totally from scratch?

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    1) Nope, completely different
    2) Probably

    A bit of expansion. The basics of most programming languages are the same, you usually have datatypes, you will have loops, If/Then/Else constructs etc. eg:
    Please Login or Register  to view this content.
    What differs are the concepts, so the thing you will have to get your head around are Objects, specifically creating and using classes (it's possible for a language to be object orientated without having classes). This will be the learning curve, VBA sugar coats this and you use classes all the time, you just don't know you are - Forms are Classes, as are the Sheet modules and ThisWorkbook module, in C#/VB you're expected to understand their uses - they're not complicated really though, so it's just a case of working through

  7. #7
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Alright great..

    Then I guess I will take up either of C# or VB.Net very very soon..

    Thank you for the clarification..

  8. #8
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Hi!

    I found this interesting article, so thought of sharing it for anyone reading this post or comparing VB.Net Vs C#.. BTW, this is the only article FOR VB.Net that I'v found.. So by no means, I am claiming VB.Net to be better than C# or something..

    https://www.simple-talk.com/dotnet/....better-than-c/

    It's interesting to me as Andy Brown from Wise Owl Training has written it. (Someone I'v learnt quite a bit from over YouTube!)
    Last edited by NeedForExcel; 07-27-2015 at 02:03 AM.

  9. #9
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Whilst interesting, it's all opinion, it should really be titled "why I prefer vb over c#". Why not try them both and see which you prefer. C# has a c like syntax - hence the name, this makes it much more terse and you generally have to write less code to get things done, it also does not use white space for control flow, that's what the semicolon is for you can put any bit of your statement on any line, this is useful for readability. You've also got the advantage that once you get your head round the syntax, other languages will be much easier to pick up - most of them use the same operators for example.

    On the flip side vb is more verbose, whilst it requires more code to do the same thing it's a bit more readable, you won't have anywhere near as much hep when learning the language and I suggest that you pick up some c# too if you choose vb. the reason for this is that most of the examples and tutorials you see will be written in c#, it's pretty easy to convert them to vb, you just need to work out what's going on first.

  10. #10
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    It's a very confusing choice..

    But what you are saying is absolutely right..

    Guess I should watch some Videos of VB.Net & C# Both on YouTube before actually deciding what interests me..

  11. #11
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    No, don't watch videos, just do the same project in both and see which you prefer. There isn't a right or wrong answer, it's just preference, you'll only find the one you like by trying them

  12. #12
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Difference between VBA & VB (Using Visual Studio)

    Kyle if you are still following this, I have a question.

    So I have the free version of Visual Studio and I have a box and at the top it says Installed and when you expand that it shows templates and when you expand that, Visual Basic, Visual C#, Visual C++, SQL Server, Python, Visual Studio Solutions. I always thought the Visual Basic it referred to was just the old Visual Basic, so is it actually .net even though it just says Visual Basic?
    Thanks.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

  13. #13
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Yep, it's .net, not classic VB. Quite confusingly MS decided to keep the name despite the fact it's not the same language

  14. #14
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Quote Originally Posted by skywriter View Post
    I always thought the Visual Basic it referred to was just the old Visual Basic, so is it actually .net even though it just says Visual Basic?
    I actually thought the same, till Kyle clarified in Post #2.

    @Kyle -

    I also came to know something about Visual Studio Express.. I downloaded the 2010 Version. I understand it is free, just wanted to know If it has everything that I would require while learning? I also wanted to know, if SSMS comes along with it, or will I need to get it from somewhere?

  15. #15
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Bill Gate's VB dream was lost somewhere between VB and VB.Net. Whereas he wanted a 'RAD' (rapid application development) programming environment more accessible to 'power users', VB.Net has gone the way of C, ie. cumbersome. Good for purist programmers, bad for engineers.

    Obviously the 'right' advice to give you is to go VB.Net, since that is what is supported these days.

    But IF you know vba well already (and it's just vb5/6 really), then I suspect that the time required to familiarise yourself with the language AND build an Excel add-in will be much shorter with vb6 than with VB.net. The move from vba to vb.net can be quite steep, and usually only undertaken if you intend to use it a lot in the future, eg. professionally.

  16. #16
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    I doubt that with VB.Net that I will ever see the days again where I can outstrip a team of 10 C++ programmers writing an equally complex program, by a factor of 10. I totally freaked them out.

  17. #17
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    @skywriter, post #12. I'm not sure your Visual Studio is .Net. VS's existed before .Net. If you recently acquired it off the net, it's unlikely though, that'd be .Net. VB5 and VB6 executables are called that (vb5.exe etc), and should be dated 1998 or earlier.

  18. #18
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    @cyiangou

    Thank you for the advice.. After Kyle clarified some of my Queries, VB is out of question..

    I am going to take up either C# or VB.Net.

    I am aware it will take more time, but it is something I will need to do..

  19. #19
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Good, that's the right choice. But it's not for casual use. If you don't use it, you lose it.

  20. #20
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Quote Originally Posted by cyiangou View Post
    I doubt that with VB.Net that I will ever see the days again where I can outstrip a team of 10 C++ programmers writing an equally complex program, by a factor of 10. I totally freaked them out.
    I'd be surprised if you couldn't, but you should also do the same with any high level language / framework - or there wouldn't be much point in it. They aren't the same thing, it's like saying you can assemble flat pack table 10x faster than a cabinet maker can make a piece of furniture - it's horses for courses.

    What makes you think you can't develop in .net as fast as classic VB? I'd say on the whole that's unfair, the .net framework does so much that you'd have to hand roll in VB6, I reckon it's much faster to develop in .net. Is it as simple? Probably not, you've got to learn OOP, but the resulting code is likely much cleaner. About the biggest advantage you'd have with classic is portability and support, but they aren't impossible to overcome.

  21. #21
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Quote Originally Posted by NeedForExcel View Post
    I actually thought the same, till Kyle clarified in Post #2.

    @Kyle -

    I also came to know something about Visual Studio Express.. I downloaded the 2010 Version. I understand it is free, just wanted to know If it has everything that I would require while learning? I also wanted to know, if SSMS comes along with it, or will I need to get it from somewhere?
    Yes, it will have, it's just missing the ability to have Visual Studio add-ins. Depending on your use case, you could also check out the Visual Studio Community Edition - it's the same as the pro version, but free for certain use cases. https://www.visualstudio.com/en-us/p...munity-vs.aspx

  22. #22
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Alright great!

    I will check it out..

  23. #23
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    P.S you only need ssms if you're planning on using SQL server

  24. #24
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Quote Originally Posted by Kyle123 View Post
    P.S you only need ssms if you're planning on using SQL server
    Yes I do plan to use SSMS.. Which Database you suggest if not SSMS?

    And does it come along with the VS Express 2010 Edition?

  25. #25
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Ok, you've got the terminology a bit mixed up.

    SQL Server (and SQL Server Express) is a database - it doesn't have a GUI
    SSMS (SQL Server Management Studio) is an Admin/Reporting/Designing application for working with SQL Server

    You *can* get away with not using SSMS for basic stuff, you can get away with just using Visual Studio, but I'd rather use SSMS

    I don't think it comes with VS Express, I think it comes packaged with SQL server

  26. #26
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Also why 2010? The updates are iterative, so they generally get better each year

  27. #27
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Actually I am using SSMS at work, and I have MySQL at home.. So can I use MySQL with VSE 2010 if I do not have SSMS? I also believe there is something called SSMSE, which is free..

    Quote Originally Posted by Kyle123 View Post
    Also why 2010? The updates are iterative, so they generally get better each year
    That is because my Computer Hardware sadly does not support the 2013/2015 VSE Version..

  28. #28
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    What makes you think you can't develop in .net as fast as classic VB?
    Having worked professionally on VB1 through VB6 (1991 - 2007) and Vb.NET since then, I feel I can make a good judgement on this score. Once you've spent your first 6 months building your libraries to restore your former productivity, then maybe. Don't get me wrong, I'm a fan of .net, I just miss VB6 for certain kinds of development.
    Last edited by cyiangou; 07-27-2015 at 05:42 AM.

  29. #29
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    SSMS is just the 'IDE' for a SQL Database as Kyle says. I use the free editions of SQL Server 2005 and 2008R, perfectly adequate for all your development needs.

  30. #30
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    The ease of creating exes that you can distribute can indeed be handy.
    I use the free editions of SQL Server 2005 and 2008R, perfectly adequate for all your development needs
    With an important caveat - as long as you only have small databases

  31. #31
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Only once or twice in my career have I needed databases that are 4 (2005) or 8 (2008R) GBytes or bigger. Even then, you'd rather work on cut-down versions that are practical to carry around for development.

  32. #32
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    That depends what your environment is, currently our database is 67GB, which I don't consider particularly large. If you're talking about locally installed databases then you may have a point, but not for shared databases. Also, you ideally want to fit the database in the RAM, it makes performance soooo much faster, granted, not always possible, but the Express version is nerfed to 1GB of RAM.

    Good news is that the express versions now support up to 10GB databases

  33. #33
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    So do I consider that If I am using it for learning, I do not need SSMS. I can use SQL Server which comes along with Visual Studio.

  34. #34
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    No, I don't think that sql server comes with VS (though I may be wrong). Want 3 things:

    SQL Server
    SSMS
    Visual Studio

  35. #35
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Alright great.

    Thank you for supporting me in such threads. I sometimes feel really dumb while asking such questions.. But I gotta do it..

  36. #36
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    No Problem

    Thanks for the rep

  37. #37
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Agree with those 3 essentials, and thank you also.

  38. #38
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Hi,

    I Downloaded the Visual Studio 2010 Version. However, I do not find any options that allows Office Development.

    Is it not available in the Express Versions?

  39. #39
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    I can't remember, I seem to think not. You might need the 2013 community edition, but if it doesn't run on your machine, you may well be stuck

  40. #40
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)


  41. #41
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    That's a problem then..

    Regarding VS 2013, are you sure Office Dev is possible in the Express Version? Coz I cannot find details about it on Wiki!
    Last edited by NeedForExcel; 07-28-2015 at 06:41 AM.

  42. #42
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    It's not express, it's the community version. It's the standard pro version, but free for the correct usage.

    Yes, it's supported, it's just an addin http://stackoverflow.com/questions/2...munity-edition

    It will not work on the express versions

  43. #43
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    You might find some useful info here:
    http://stackoverflow.com/questions/8...-visual-studio

  44. #44
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    @Kyle - Great, It means If I can get the 2013/2015 Community Version Working on my Hardware, then I am sorted..

    @cyiangou - Thank you for the link.. Its a very helpful one..

  45. #45
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    @Kyle - You had also mentioned in an earlier post #4 "Well you can make them with VBA in excel.".

    Is it possible to make Add-ins that manipulate the Excel Ribbon using VBA too?

    https://msdn.microsoft.com/en-us/library/aa338202.aspx

  46. #46
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    If you're just talking ribbons; that's real easy. Get:
    Custom UI Editor For Microsoft Office (free)

    EDIT:
    Sorry, not reading your question properly. This is for making ribbons, not making add-ins that manipulate ribbons.

  47. #47
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Quote Originally Posted by cyiangou View Post
    Sorry, not reading your question properly. This is for making ribbons, not making add-ins that manipulate ribbons.
    It is still useful.. I did not know about this and thank you for letting me know..

  48. #48
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Oh yes. If you just want to create some slick UI-based vba functionality (like immediately), then this is the way to go. Here's a ribbon I've built:

    ribbon.jpg

  49. #49
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    This is insane.. But what are those XML Strings?

    I mean, how do I learn to use them?

  50. #50
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    Ok, I did this 3 years ago. Give me some time to update myself...
    But for now, don't worry about the xml. It wasn't as intimidating as it looks.

  51. #51
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Andy's is quite nice, means that you don't have to faff with the xml manually http://www.andypope.info/vba/ribboneditor_2010.htm

  52. #52
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    That is awesome guys.. This is amazing information I didn't know about..

    Quote Originally Posted by Kyle123 View Post
    Andy's is quite nice, means that you don't have to faff with the xml manually http://www.andypope.info/vba/ribboneditor_2010.htm
    I actually want to learn how to do all of that manually in the long run.. But, for the time being, It is still amazing..

    Both of ya'll have given me some amazing stuff to learn..

  53. #53
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    I'm remembering now, with the UI editor you also don't have to edit the xml directly. You have a treeview-based graphical interface, and you just link your vba routines to the buttons you create. Give it a go, I estimate you'll have your first working ribbon done today.

    I found their instructions very easy.

    There's a video here:
    https://www.youtube.com/watch?v=ZTt2FFyj2Fo

  54. #54
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    But RibbonX looks amazing. Didn't see it around 3 years ago...

  55. #55
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    So what do things like RibbonX or Custom UI Editor For Microsoft Office offer that cannot be done with just VBA? Apart from having buttons on the Ribbon..

  56. #56
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Difference between VBA & VB (Using Visual Studio)

    Nowt. They're just for editing the ribbon xml, you can do it with notepad if you're so inclined - the the tools make it easier

  57. #57
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Difference between VBA & VB (Using Visual Studio)

    Ok great!

    Don't want to bug both of ya'll more..

    I have enough information to study for the week..

    Cheers!
    Last edited by NeedForExcel; 07-28-2015 at 08:00 AM.

  58. #58
    Valued Forum Contributor
    Join Date
    09-17-2012
    Location
    Johannesburg, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    454

    Re: Difference between VBA & VB (Using Visual Studio)

    It's the editors that build the Excel-compatible xml that defines a .xlam file (a ribbon add-in).

    EDIT:
    Excel files these days are just xml files wrapped in a zip file.
    Last edited by cyiangou; 07-28-2015 at 08:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Visual Studio program
    By cdllt in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 10-13-2013, 01:18 AM
  2. Visual Studio Just-In Time Debugger
    By jo15765 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2012, 11:35 AM
  3. Creating macro from visual studio
    By dhruvan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-03-2007, 07:13 AM
  4. Visual Studio 2005
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2006, 03:16 PM
  5. [SOLVED] visual studio
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-02-2005, 02:30 AM
  6. Replies: 1
    Last Post: 09-13-2005, 07:06 AM
  7. excel object in visual studio
    By Easwaran in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-09-2005, 09:05 AM
  8. [SOLVED] Visual Studio .Net C# and Excel
    By Adam in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-24-2005, 12:06 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1