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

John Bixtis wrote:
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

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)

"John Bixtis" wrote in message
...
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

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
"John Bixtis" wrote in message
...
| 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
|
|

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

--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
--------------------------------------------
Share your knowledge. Add your favorite questions and answers
Help add questions to this site! We want Your input.
--------------------------------------------
"Jim Rech" wrote in message
...
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
"John Bixtis" wrote in message
...
| 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
|
|