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: 18
Default Best Excel Development Architecture? VSTO vs. VBA vs. VB.Net/C#.Netvs. ???

Hi,

First of all, I'm an experienced programmer in a few languages,
including C#, but have not yet learned VBA or VB.Net beyond
rudimentary code.

However, my new employer is a heavy user of Excel, and it would
behoove me to learn to maximize its capabilities.

I've read a number of web articles indicating that VSTO is the
successor to VBA. However, I've also read it does not work with
Visual Studio Express. Is this still the case with VS Express 2010?
If so, then Microsoft wants me to use VSTO in favour of VBA, yet wants
me to spend $$$ for the high end VS Suite? I don't understand this
marketing - I would think it would limit the uptake of VSTO? There is
no way I will get justification to buy VS just to use VSTO vs. VBA.

I've also read he
http://groups.google.com/group/micro...c3 0ee38f2b52
that VBA can be used to call a .dll.

Given the above, what would you recommend as the best architecture for
me to learn to automate Excel's capabilities?

Thanks,
Scott
 
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
Architecture Question Steve Haack Excel Programming 2 January 31st 07 08:02 PM
RTD server architecture - single topic update LJ[_3_] Excel Programming 0 March 12th 06 02:53 PM
Progamatically Formating Cells within VSTO for Excel Application Development using C# Sharad Vyas Excel Programming 5 December 10th 05 04:42 AM
.NET, CAS and Excel Development Scott Gauthier Excel Programming 0 June 17th 05 10:56 PM


All times are GMT +1. The time now is 06:14 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"