C# instead of VBA

[John Bixtis]

Hi all,

A silly question perhaps.

I am a student and my worst nightmare is the syntax of VB. I would like to
be able to use C syntax in Excel functions and macro programming.

Is there any speculation that Microsoft may replace VBA by C# in the near
future?


Many Thanks.

John

 

[semiopen]

Hi all,

A silly question perhaps.

I am a student and my worst nightmare is the syntax of VB.

You must have some pretty tame nightmares! You need to rent some
horror movies or something - make your nights more interesting.

I would like to
be able to use C syntax in Excel functions and macro programming.

Most of the difference is just synactic sugar (compared to something
like Lisp which is *really* different). Things like "End If" instead of
a generic "}" , etc. Why not develope a sweet tooth? VBA *is* more
verbose than C - I'll grant you that - but the upside is that it is a
heck of a lot easier to debug. You can actually tell which block of
code your End statements are ending whereas it is sometimes difficult
to tell just how a C compiler is interpreting a }

Is there any speculation that Microsoft may replace VBA by C# in the near
future?

It won't happen - a macro language has to be intuitive enough for
non-programmers to pick up on their spare time in order to write short
macros (while still providing tools for professional developers). But
then again - no one thought Microsoft would axe VB6 in favor of Visual
Fred (aka VB.Net) so you may luck out.

Many Thanks.

Your welcome I guess

John

-semiopen

 

[Bob Phillips]

If they did it would cause an almighty fuss, there are a LOT of VBA
solutions out there in the wide world.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Jim Rech]

I very much doubt that the Excel VBE will ever become anything else. Your
alternative is to use Visual Studio and the Visual Studio Tools for Office.
I think MS will let the VBE stay as it is in the future while focusing on
making the Tools better with each version. At present however I'm not too
sure they are a practical replacement for the VBE for routine macros.

--
Jim
| Hi all,
|
| A silly question perhaps.
|
| I am a student and my worst nightmare is the syntax of VB. I would like to
| be able to use C syntax in Excel functions and macro programming.
|
| Is there any speculation that Microsoft may replace VBA by C# in the near
| future?
|
|
| Many Thanks.
|
| John
|
|

 

[HSalim[MVP]]

John,
Worst nightmare, huh? What is so bad about it?
Can you elaborate on that?
Thanks
HS