VBA or VSTO or Both

[Tomred]

It's a while since I looked at Excel and need to brush up on it.
I write to ask if I'd be best to drop VBA and start learning VSTO.

I currently have Excel 2003 but plan to get a more recent version.
Which I'm not sure about either ?

Any advice would be much appreciated.

 

[RoryA]

VSTO is not a language-it's a set of tools. when using VSTO you can choose to program in C# or VB.Net

 

[Tomred]

Smitty Wrote:

Gerard's book is a good one, but a bit dated now I think.

From what you've explained I can appreciate that. It has clarified a few fundamentals for me though.
I think the .net path is probably the most future proof path as many folk that worked with VB6 moved to it,
because VB6 no longer got support form what I've picked up.