Moving past VBA

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
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
 

XL-Dennis

New member
Joined
Mar 21, 2011
Messages
12
Reaction score
0
Points
0
Location
Östersund, Sweden
Website
xldennis.wordpress.com
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#.
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Thanks Dennis. Do you have a quick example of what sort of things would require C#?
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Thanks Roy, I hadn't seen Excel DNA before, I'm going to check it out for sure.

Jesse
 

XL-Dennis

New member
Joined
Mar 21, 2011
Messages
12
Reaction score
0
Points
0
Location
Östersund, Sweden
Website
xldennis.wordpress.com
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
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Thanks Dennis, this article is excellent. Exactly what I needed.

Jesse
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Jesse, be aware, at present Reporting Services only talks VB.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Jesse, another thing to be aware of. Once you start fooling around in Visual Studio you're going to learn just how far behind Excel's development environment really is. :(
 

Jesse

New member
Joined
Mar 22, 2011
Messages
51
Reaction score
0
Points
0
Thanks Ken, I consider myself warned :)

Thanks all for the advice, I think I'm going to jump into Visual Studio via C#.

Jesse
 

lingmaaki

New member
Joined
Sep 25, 2012
Messages
1
Reaction score
0
Points
0
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.
 

XL-Dennis

New member
Joined
Mar 21, 2011
Messages
12
Reaction score
0
Points
0
Location
Östersund, Sweden
Website
xldennis.wordpress.com
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.
 
Top