LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Alternatives to VBA for Excel programming

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 a
- 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternatives for Excel when too few rows Jesper Excel Discussion (Misc queries) 6 April 2nd 08 11:03 PM
Alternatives to Excel Spider Excel Discussion (Misc queries) 2 March 1st 05 01:03 PM
Pocket Excel Alternatives? MB7 Excel Discussion (Misc queries) 0 February 16th 05 04:03 PM
Alternatives to VBA in Excel Thomas Kregeloh Excel Programming 7 June 10th 04 02:57 AM
OLDEDB alternatives for pulling data from Excel Glenn Thimmes Excel Programming 0 April 14th 04 03:37 PM


All times are GMT +1. The time now is 05:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"