A
AllSensibleNamesTaken
I am looking for a fully ObjectOriented language (one of the .NET languages
being the obviou choice) but with exacly the same ease of interoperability
with Excel that VBA currently provides.
The main factors in the Excel VBA relationship that provide the ease of
interoperability I'm reffering to are:
- Macro recording from Excel actions producing code that can be studied
and modified. This code would now need to be in the a .NET language. Ideally
the .NET language chosen by the user.
- Embedding of code within the Excel document so that the code and
document can be depoyed as a unit. This could be done directly (analogous to
"By Value" ) or via references, which I think is even better.
- Seamlessless debugging capability of code triggered by Excel actions
- Ease with which one can write a function and have it be immediately
called from within Excel cells
- Control Toolbox toolbar to generate controls that can be easily
identified and behaviorally implemented in code.
Have the users of this forum found something like this?
I am being told that VSTO can bring .NET languages to office, but with
nowhere near the ease of interoperability that VBA can (as described above)
Any comments from people that have looked for this and/or found it are vey
much appreciated.
Thanks so much
being the obviou choice) but with exacly the same ease of interoperability
with Excel that VBA currently provides.
The main factors in the Excel VBA relationship that provide the ease of
interoperability I'm reffering to are:
- Macro recording from Excel actions producing code that can be studied
and modified. This code would now need to be in the a .NET language. Ideally
the .NET language chosen by the user.
- Embedding of code within the Excel document so that the code and
document can be depoyed as a unit. This could be done directly (analogous to
"By Value" ) or via references, which I think is even better.
- Seamlessless debugging capability of code triggered by Excel actions
- Ease with which one can write a function and have it be immediately
called from within Excel cells
- Control Toolbox toolbar to generate controls that can be easily
identified and behaviorally implemented in code.
Have the users of this forum found something like this?
I am being told that VSTO can bring .NET languages to office, but with
nowhere near the ease of interoperability that VBA can (as described above)
Any comments from people that have looked for this and/or found it are vey
much appreciated.
Thanks so much